is there a way to grant select to an entire schema or does it have to be done table by table?
Printable View
is there a way to grant select to an entire schema or does it have to be done table by table?
table by table
is there an easy way to do some sort of wildcard i could use:
like SCHEMA_*
?
No magic Pixi dust...Quote:
Originally posted by tron
is there an easy way to do some sort of wildcard i could use:
like SCHEMA_*
?
OBJECT by OBJECT
Write a script to generate the SQL.
Alternatively, you might want to investigate GRANT SELECT ANY TABLE privs.
werd...goin with the script...thanks all.