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]

Reply via email to