-
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.
Thanks
-
can JOHN_DO do :
desc A ???
or select * from A ???
-
pipo,
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.
Doug
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|