DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: PRIVILEGES/SECURITY

  1. #1
    Join Date
    Aug 2001
    Posts
    390
    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

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    can JOHN_DO do :
    desc A ???
    or select * from A ???

  3. #3
    Join Date
    Aug 2001
    Posts
    390
    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 ???


  4. #4
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    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
  •  


Click Here to Expand Forum to Full Width