Oracle Database Discussions

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!

ORA-02030: can only select from fixed tables/views

440674Apr 29 2005 — edited Apr 29 2005

Hi

I need to grant object privs to a user and he has to have access to select certain system views as v$lock, v$session ..., but when I try to grant them it shows the error ORA-02030.

How can I grant those tables or views????

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2005

Added on Apr 29 2005

#general-database-discussions

2 comments

2,390 views