Posted by: the_hareeb October 11, 2009
Login in to Rate this Post:
0 
? 
?
GRANT all on author to Accountant with grant option;
Error starting at line 1 in command:
GRANT all on author to Accountant with grant option
Error report:
SQL Error: ORA-01926: cannot GRANT to a role WITH GRANT OPTION
01926. 00000 - "cannot GRANT to a role WITH GRANT OPTION"
*Cause: Role cannot have a privilege with the grant option.
*Action: Perform the grant without the grant option.
----------------------
This is what i did..
GRANT all on author to Accountant;
GRANT Accountant to AMARTIN;
SELECT * FROM ROLE_TAB_PRIVS WHERE ROLE = 'Accountant';
returns:
ROLE OWNER TABLE_NAME COLUMN_NAME PRIVILEGE GRANTABLE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- ---------
0 rows selected