Table Level Privileges

Table Level Privileges

select owner, table_name, privilege, grantee from dba_tab_privs where owner='EBS_OBJ'

and table_name in ('SUBSCRIPTION_AGREEMENTS','SUBSCRIPTION_ITEMS') and grantee = 'CDS_MIGRATOR_USR';

OWNER                          TABLE_NAME                     PRIVILEGE                                GRANTEE
------------------------------ ------------------------------ ---------------------------------------- -------------------
EBS_OBJ                        SUBSCRIPTION_AGREEMENTS        SELECT                                   CDS_MIGRATOR_USR
EBS_OBJ                        SUBSCRIPTION_ITEMS             SELECT                                   CDS_MIGRATOR_USR