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 -- Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]