SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

grant select on all tables of a schema

406353Jan 23 2007 — edited Jan 23 2007

I need to grant select on all tables (over 200 tables) of a schema to other users. Are there any SQL syntax to do this?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2007

Added on Jan 23 2007

3 comments

719 views