privilege granted to role on table disappears
499068Mar 16 2006 — edited Mar 16 2006I have a similar situation with two 9.2.0.1 DBs on a Solaris 8 development server. I have created a role FIRETRAK_QUERY_ROLE and granted select on 4 tables to said role. The role has been granted to user FIRETRAK_QUERY as the default and only role. Each day the granted privilege disappears from table 1 but is still intact on the other tables.
The same problem occurs in another database with the same scenario and only on two out of 48 tables. The latter database is setup identically on a Solaris 8 production server and we don't have the problem with that instance. The only thing that happens consistently is a daily hot and monthly cold backup. Has anyone seen this before?
Thanks,
Barb