List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:April 14 2007 3:03am
Subject:Re: a little user rights help?
View as plain text  
Well, that look like a simple way to achieve your goal.

connect to db as AdminTyp2, get usercredentials (select),
reconnect with users AdminType.

Normaly i handle stuff like that in the application.
No need to display a delete button, if the action will
fail anyway (with an ugly mysql error).

-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224


On Fri, April 13, 2007 22:18, Denise Wilson wrote:
> Hi.  I'm brand new at this so I'm looking for a little help.
>
> I need to have two difference levels of access to a mysql database that I
> am
> developing for our librarians to use to maintain the various research
> resources we have available in our library.  AdminType1 should have
> Delete,
> Insert, Select, and Update rights on all the tables in the Resources
> database.  AdminType2 will have the same rights on some of the tables in
> the
> Resources database, but in other tables they should only have Select
> rights.  At the moment, my plan is to have a separate user database that
> will contain a table with a row for each librarian and a column that will
> hold information about whether the librarian is AdminType1 or AdminType2.
> I
> plan to set up 2 users in the grant tables of the mysql database.
> AdminType1 will be granted the more comprehensive rights to all the tables
> in the Resources database and AdminType2 will be granted the Delete,
> Insert,
> and Update rights only on the appropriate tables.  After the user has
> logged
> into my user database, they will be connected to the Resources database as
> either user AdminType1 or AdminType2.
>
> My Question:
> Is this a good way to approach this or am I WAY off base?
>
> Denise
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
>



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

Thread
a little user rights help?Denise Wilson14 Apr
  • Re: a little user rights help?Mogens Melander14 Apr
  • Re: a little user rights help?Baron Schwartz14 Apr