how to grant select privileges on v$views to a user
Due to some business requirements, i'm asked to give ONLY select privileges to a user. When i'm trying to give command like...
SQL> conn / as sysdba
SQL> grant select on v$session to XYZ;
grant select on v$session to XYZ
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
How can i grant only select privileges to a user? Please let me know the syntax...
I've to give these permissions on both machines with..
Oracle 8.1.7 Linux 6.2
Oracle 22.214.171.124 Linux 7.2
Thanks in advance
Click Here to Expand Forum to Full Width