ORA-01720: grant option does not exist for


ORA- Error:


SQL> GRANT SELECT on MP_DEPORT_ARTEX_PS_AGR to ORACLE_ASA_ROLE;
GRANT SELECT on 
MP_DEPORT_ARTEX_PS_AGR to ORACLE_ASA_ROLE
*
ERROR at line 1:

ORA-01720: grant option does not exist for 'NEW_ASU_USER.ASU_FINAL_PO_AGR'

SQL>SHOW USER
"NEW_ALT_USER"


Cause:


"NEW_ALT_USER" do not have privilege to grant a SELECT on a table owned by "NEW_ASU_USER" to any other user or role


SQL> select * from all_tab_privs where table_name='ASU_FINAL_PO_AGR';

GRANTOR GRANTEE TABLE_SCHEMA TABLE_NAME PRIVILEGE GRANTABLE HIERARCHY
------- -------- ----------- ----------- -------- -------- ---------
NEW_ASU_USER ORACLE_UPD_ROLE NEW_ASU_USER ASU_FINAL_PO_AGR SELECT NO NO 



Solution:

Login as a owner of the table "NEW_ASU_USER" and grant permission to "NEW_ALT_USER" with grant Option.


SQL>SHOW USER
"NEW_ASU_USER" 
SQL> grant select on NEW_ASU_USER.ASU_FINAL_PO_AGR to NEW_ALT_USER with grant option;

Grant succeeded.



No comments:

Post a Comment