Hello,

I'm surveying the MySQL privilege system... as long as roles don't seem
to be implemented, I'm running some tests about emulating roles with
stored procedures granting privileges.

It doesn't sounds possible with the regular GRANT statements, just
because of syntax problems, but it seems OK when directly editing
mysql.user, mysql.db and the like.

Do you think this is the right way ? Has anyone already tried to manage
users with stored procs ?

Thanks for any feedback !

Antoun

Hi,

this is definitely possible - I plan to do something similar to emulate
roles. No doubts that it works ;-).

Markus


"Antoun" <antoun (AT) free (DOT) fr> schrieb im Newsbeitrag
news:44846e64$0$1612$636a55ce (AT) news (DOT) free.fr...