Verify Granted privileges by using as of timestamp
Verify Granted privileges by using as of timestamp
Had to verify the granted privileges/permissions in different timings in one of the deployment activities. Below timestamps were from “SET TIME ON” from each SQL command that were executed.
SQL> select GRANTEE from dba_tab_privs AS OF timestamp to_timestamp (‘2013-04-16 10:45:31′,’YYYY-MM-DD HH24:MI:SS’)
2 where table_name=’DEALER_MERGER’ and privilege like ‘SELECT’ and owner=’ADM’;
GRANTEE
——————————————————————————–
EA_USER_ROLE
DLRL
MINR
MPS
USR
DLRL_USR
STAGE
STAGE_USR
LABS
ACCT_ADM
ANET_USR
ANET_READ
LEASE_USR
LAPISW1
ADM_RT
15 rows selected.
SQL> select GRANTEE from dba_tab_privs AS OF timestamp to_timestamp (‘2013-04-16 10:50:31′,’YYYY-MM-DD HH24:MI:SS’)
2 where table_name=’DEALER_MERGER’ and privilege like ‘SELECT’ and owner=’ADM’;
GRANTEE
——————————————————————————–
EA_USER_ROLE
USR
STAGE
STAGE_USR
LAPISW1
SQL> select GRANTEE from dba_tab_privs AS OF timestamp to_timestamp (‘2013-04-16 10:55:31′,’YYYY-MM-DD HH24:MI:SS’)
2 where table_name=’DEALER_MERGER’ and privilege like ‘SELECT’ and owner=’ADM’;
GRANTEE
——————————————————————————–
EA_USER_ROLE
LAPISW1
See also