| Granted privileges but not able to see in DBA_SYS_PRIVS table [message #514380] |
Mon, 04 July 2011 06:51  |
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
|
Junior Member |
|
|
Hello All,
I have been granting "ALTER ANY MATERIALIZED VIEW" to a role but not able to see the same granted in DBA_SYS_PRIVS.
Please find the example I have:
*************************************************************************************
*************************************************************************************
I have used the image for the first time, so pasting the sql prompt output as well:
*************************************************************************************
SQL> select * from v$version where banner like 'Oracle%';
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
SQL> grant ALTER ANY MATERIALIZED VIEW to OPS_1ST_LINE;
Grant succeeded.
SQL> select * from dba_sys_privs where grantee = 'OPS_1ST_LINE';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
OPS_1ST_LINE CREATE SESSION NO
OPS_1ST_LINE ALTER ANY SNAPSHOT NO
SQL> commit;
Commit complete.
SQL> select * from dba_sys_privs where grantee = 'OPS_1ST_LINE';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
OPS_1ST_LINE CREATE SESSION NO
OPS_1ST_LINE ALTER ANY SNAPSHOT NO
SQL> SELECT * FROM DBA_SYS_PRIVS WHERE PRIVILEGE = 'ALTER ANY MATERIALIZED VIEW';
no rows selected
*************************************************************************************
Please let me know why is this grant not been shown. Is "ALTER ANY MATERIALIZED VIEW" not present for Oracle 9i database.
Thanks
Shamsh Pervaiz
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
