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

391014Jun 14 2007 — edited Jun 15 2007

Is there a direct SQL to grant select on all tables in the schema for a user? Or do we need to write a PLSQL for this?

Also, if a new table T1 is created or existing table T2 is dropped and recreated after granting the select all privilege, will the user have access to T1 and T2?

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2007

Added on Jun 14 2007

2 comments

507 views