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 on all views

User_7X4SWSep 5 2013 — edited Sep 5 2013

Hi All,

I have 2 schemas/users , User_1 and User_2

Under User_1 i have many views created.

I wishh User_2 to have select access on all views of User_1 but in a fashion that if in FUTURE any view is created, User_2 automatically get access to it.

It should be like .. GRANT SELECT ON ALL VIEWS OF USER_1 to USER_2.

please let me know if it is possible and how?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2013

Added on Sep 5 2013

#on

6 comments

5,528 views