[EMAIL PROTECTED] wrote > 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 ???
All users of one usergroup have the same privileges --> no chance to do this with a usergroup. But what about using SYNONYMs? As normaluser once for each table: CREATE SYNONYM <tabname> FOR programmer.<tabname> http://dev.mysql.com/doc/maxdb/en/6d/117c2fd14811d2a97400a0c9449261/frameset.htm You could use PUBLIC SYNONYMS as well, but this may be some overkill (in case other users are available in your DB). Elke SAP Labs Berlin > > 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]
