grant for schema

[tron]

is there a way to grant select to an entire schema or does it have to be done table by table?

[slimdave]

table by table

[tron]

is there an easy way to do some sort of wildcard i could use:

like SCHEMA_*

?

[alapps]

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.

[marist89]

Alternatively, you might want to investigate GRANT SELECT ANY TABLE privs.

[tron]

werd...goin with the script...thanks all.