Andreas Goldstein wrote : > >Hi Listmembers, > >can I use schemas to build logical units of database-objects >for an easier >privilege-management? > >What I am thinking of is somethin like this: >DBAdmin creates a schema SCHEMA_FOO and places some tables in it. > >Then he uses a command like >GRANT SELECT, UPDATE, INSERT ON SCHEMA_FOO TO USERGROUP_BAR >to give the members of USERGROUB_BAR the three privileges on >all DB-Objects >inside the schema. > >Is something like that possible? > >THX & Regards > >
This currently is not possible. You could try to write a db-procedure that does the job. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
