给普通用户ef_test授权查看v$session_longops动态视图:
SQL> grant select on v$session_longops to ef_test;
grant select on v$session_longops to ef_test
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
由于v$和v_$视图是同义词,所以可以对v_$视图授权
SQL> grant select on v_$session_longops to ef_test;
Grant succeeded.
成功授权!
SQL> grant select on v$session_longops to ef_test;
grant select on v$session_longops to ef_test
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
由于v$和v_$视图是同义词,所以可以对v_$视图授权
SQL> grant select on v_$session_longops to ef_test;
Grant succeeded.
成功授权!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7353848/viewspace-681370/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7353848/viewspace-681370/