I have a role named BG and this role have insert, update, delete, select to a table named A. This BG role has been granted to the user name JOHN_DO. I don't have any other roles granted to this user. When I tired to delete data from this user I have unsufficient privileges.
When I created another role say DEVELOPER and grant delete any tables to DEVELOPER and it works fine.
Can someone explain to me why I need to have DEVELOPER in order for me to delete the table even that table has been granted to BG role and BG has been granted to the user.
can JOHN_DO do :
desc A ???
or select * from A ???
thanks for your reply,
JOHN_DO was able to do select and desc from table A without DEVELOPER role.
Do you have any hint why it's doing that ???
Check to see if there are constraints or triggers which this delete may be triggering.
Click Here to Expand Forum to Full Width