is there a way to grant select to an entire schema or does it have to be done table by table?
table by table
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
is there an easy way to do some sort of wildcard i could use: like SCHEMA_* ?
Originally posted by tron is there an easy way to do some sort of wildcard i could use: like SCHEMA_* ? No magic Pixi dust... OBJECT by OBJECT Write a script to generate the SQL.
alapps Fast, Cheap, Reliable... Pick Two(2)
Alternatively, you might want to investigate GRANT SELECT ANY TABLE privs.
Jeff Hunter
werd...goin with the script...thanks all.
Forum Rules