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).
+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
> developing for our librarians to use to maintain the various research
> resources we have available in our library. AdminType1 should have
> 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
> 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.
> 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,
> and Update rights only on the appropriate tables. After the user has
> 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?
> 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.