Oracle database error code ORA-01464 – circular grant (granting to grant ancestor) of table or view

Oracle Database Error Code ORA-1464 Description :
circular grant (granting to grant ancestor) of table or view
Error Cause:
The user in the TO clause of the GRANT statement has already been GRANTed privileges on this table.

How to Solve :
Do not GRANT privileges on a table to the user who originally GRANTed privileges on that table. The statement in error is probably unnecessary.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»