Hi,
We are currently migrating our database from ADABAS-D to MaxDB which is not a
very difficult task as these two databases are very similar.
Anyway, there seem to be differences with the namespace.
I want to create a user "admin" that has privileges to create tables, so use
DDL statements. This seems to be a "RESOURCE" user.
Next I need some users ("mitarbeiter") that can execute various DML statments
but must not drop tables etc. Those seem to be "STANDARD" users.
Is it possible that those 2 users have the same namespace? So that when
"admin" creates the table "test123", "mitarbeiter" can do a select on
"test123" and not on "admin.test123"?
First I thought about USERGROUPS but this does not seem to fit as all members
of the USERGROUP have the same privileges. On the other hand the Role concept
does probably not alter the namespace?
What do you think?
Best Regards,
Hermann
--
[EMAIL PROTECTED]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
