Privilege is not showing.
533779Feb 27 2009 — edited Feb 27 2009DB VERSION - 10.2.0.3
I've granted the " CREATE SYNINYM" privilege to one role called "DB_CONNECT". BUt, when I query role_sys_privs, it does not show.
SQL> grant create synonym to DB_CONNECT ;
Grant succeeded.
SQL> select privilege from role_sys_privs where role ='DB_CONNECT' ;
no rows selected
hare krishna