Hello list,
I'd like to give a user only SELECT privileges, database-wide. Is there an easy way to do this? I could execute a REVOKE ALL PRIVILEGES command for each table, then execute a GRANT SELECT command for each table, but that is tedious.
It would be great to do something like this:
REVOKE ALL PRIVILEGES ON * FROM user_name
GRANT SELECT ON * TO user_name
Please help me.
Aaron Dummer