Fine grained access on Alter table
sriniAug 8 2011 — edited Aug 8 2013Hi all,
I am trying to alter a table to add a new column and face the fine grained access control error -
alter table TEMP_SR add ("SHOW_WKR_CALC_RATING_FLAG" varchar2(30) DEFAULT 'Y' NOT NULL ENABLE);
Error report:
SQL Error: ORA-00604: error occurred at recursive SQL level 1
ORA-28133: full table access is restricted by fine-grained security
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack
can be corrected, do so; otherwise contact Oracle Support.
I had queried from ALL_POLICIES table to check all the policies attached to this table and found one record with
SEL= YES, INS=YES,UPD=YES, DEL=YES, IDX=NO, STATIC POLICY=NO, POLICY_TYPE=SHARED_STATIC.
Basically the VPD policy in the DB does not seem to be setup to prevent the ALTER table. Is there something else I am missing for my alter table statement to work?