Showing results for 
Search instead for 
Do you mean 

Unsecuring a table returns a privilege error

by Moderator on ‎07-22-2016 01:36 PM (426 Views)

Symptoms

When a user tried to unsecure a table, the following error occured:

 

ORA-20160: unable to grant/revoke appropriate privileges
ORA-06512: at "SYS.LT", line 8502 ORA-06512: at line 1

 

Diagnosis

 This error message occurs with both the GTM Administrator and in SQL*Plus.

Solution

Check the grants that have been made on the tables that are failing. If there are any grants, revoke them as they are the likely cause of the problem.  Privileges are handled differnetly once a table is secured and portions of the secured table is owned by WMSYS.

Contributors