Does MySQL offer anything to take the place of Oracle's roles? I'm especially interested in the ability, when adding a new table (or a new view, in the future) to the database, to be able to grant the desired access to everyone who ought to have access, without having to enumerate those people. Specifically,
GRANT SELECT, INSERT ON my_new_table TO data_tech; GRANT SELECT, INSERT, UPDATE, DELETE ON my_new_table TO research_assistant; lets you grant the necessary permissions without having to know who the research assistants are this semester, and who is on the data entry staff at this moment. Is there a similar facility with a different name in MySQL? If not, is it planned? Thanks. --Erv Young --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
