Instead of using groups have a look at using roles. I think you may need to create public synonyms though if you only want to use the table name and not owner.name
Stand to be corrected though. Regards Dave -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday 17 June 2004 16:44 To: [EMAIL PROTECTED] Subject: Help with grant and usergroups needed. Hello ! Hello ! Help with grant and usergroups needed. Just trying to understand the basics ;-) I need two kind of users in my db ! programmer (can do everything with tabels drop,alter index, delete update ....) normaluser (select,insert,update,delete) First i had two users: programmer resource not exclusive and normaluser standard not exclusive When creating a table the programmer grants select,insert,update,delete to the user. Then i recognized, that i allways have to use full tablenames with the owner in my application: (programmer.tablename) if the application should work with user normaluser (sqlpassthrough with odbc) I don't like this !!! Is there a way to have 1 usergroup: allusers resource not exclusive with 2 users (programmer and normaluser) so all the tables can be used without owner.tablename ! I don't know, how to prevent "normaluser" from alter, drop, index .... Can i revoke alter,drop, index ... from the user "normaluser" even when he is a member of the usergroup allusers ??? I don't hope, this is confusing you ??? Any help welcomed Mit freundlichen Gr�ssen Albert Beermann ''''' ''''''''' (0 0) +---------oOO-------(_)-------------------+ | Tel: 0541/5841-868 | | Fax: 0541/5841-869 | | Mail: mailto:[EMAIL PROTECTED] | | Internet: http://www.piepenbrock.de | +-------------------------------oOO-------+ |__|__| || || ooO Ooo -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
