How to grand Select access to all the schema tables that a database have to a user?
Posted on 2007-10-12
I need to find the way to grant SELECT access to all the tables that differents schemas have on a Database.
Ex: Database name ACCOUNTING contains 3 different schemas A, B and C
How to grant the user MICHAELM select access to the tables on this 3 schemas for the ACCOUNTING database. Of course without using Enterprise Manager Console.
I need a SQL to do that due the amount of tables that every schema has.
I guess is something like that but I really don't know how to user the command
GRANT SELECT ON <schema>.* TO <user>;