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)


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



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


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.