Hermann Himmelbauer wrote:
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"?
create synonym test123 for admin.test123
executed as user mitarbeiter might be a solution
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
-- Georg Thom� IEE Luxembourg S.A. IT dept. / software development / DB-administation tel. 00352/7289896810 fax 00352/7289896109 www.iee.lu / [EMAIL PROTECTED]
This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
