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
