536 total views, 11 views today

How to grant select privilege of tables and views to user;  Oracle DB

 

To grant individual table to user

 

 

 

Example:

grant select on DUAL to HR

 

To grant all tables to user

 

 

 

To Grant Individual View to User 

 

 

 

To grant all views to user

 

 

To find list of Grants user received 

 

 

select distinct ‘GRANT ‘||privilege||’ ON ‘||OWNER||’.’||TABLE_NAME||’ TO ‘||GRANTEE from all_tab_privs_recd where grantee = ‘<USER_NAME>’

govindan How to grant select privilege of tables and views to user ; Oracle DB
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan How to grant select privilege of tables and views to user ; Oracle DB
Connect me
By | 2017-05-03T08:28:30+00:00 May 1st, 2017|Categories: Oracle|Tags: , , |0 Comments
Like us on Facebook.
Connect!