the_hareeb: GRANT all on author to Accountant;..

Posted by: the_hareeb October 11, 2009

GRANT all on author to Accountant;

GRANT Accountant to AMARTIN;

SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'AMARTIN';

GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE

------------------------------ ------------------------------ ------------ ------------

AMARTIN CEO NO YES

AMARTIN ACCOUNTANT NO YES

AMARTIN CONNECT NO YES

but when i do SELECT * FROM ROLE_TAB_PRIVS WHERE ROLE = 'Accountant';

it returns nothing .. could this be the reason? it is not showing what tables Accountant role has privledges to.