Monday, 4 May 2015

Read only Permission for DBA Views

1. Login as system user in oracle DB
2. Get the list of views which the developer requested for.
3. Create the Grant statement like below :

    GRANT SELECT ON DBA_SEGMENTS TO POC; 


Note:

Syntax to revert back :

     revoke select on dba_segments from POC;

No comments:

Post a Comment