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"?
>
>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/maxdb?>[EMAIL PROTECTED]
>
Maybe public synonyms are a solution, i.e. create public synonyms for all
tables of user admin (create public synonym test123 for test123).
Best Regards,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
