Getting ora-01031 but delete priv is granted
SuSE 11 x86-64 Oracle 12.1.0.2
My user is trying to delete from a table but getting an ORA-01031: insufficient privileges, but behold: I granted delete to role lr2k_dml:
select grantor, grantee, table_name, privilege from dba_tab_privs where grantee='LR2K_DML' and table_name = 'DECODE' and GRANTOR = 'LR2K_STG';
LR2K_STG | LR2K_DML | DECODE | DELETE |
LR2K_STG | LR2K_DML | DECODE | INSERT |
LR2K_STG | LR2K_DML | DECODE | SELECT |
LR2K_STG | LR2K_DML | DECODE | UPDATE |
and granted the role to the account he's logged in as:
select grantee, granted_role from dba_tab_privs where grantee='LR2K_DML' and table_name = 'DECODE' and GRANTOR = 'LR2K_STG';