Skip to Main Content

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!

How to provide SELECT grant to user for other schema?

User_9XA6OSep 18 2019 — edited Sep 18 2019

Hi,

Due to insufficient privileges, I have created a user with the help of SYSTEM schema and now I have to give SELECT grant to this user for surdw schema from system schema.

Using the below query I can only provide the table schema for particular schema but I want to fulfill the above requirement.

GRANT SELECT ON surdw.employee TO ronna;

So could you tell me how would I archive this work?

Thanks

Comments
Post Details
Added on Sep 18 2019
3 comments
14,858 views