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

Thread: enable/disable constraint

  1. #1
    Join Date
    Jan 2001
    Posts
    138

    enable/disable constraint

    I am having trouble enabling constraint.

    Created table EMP in schema A. Granted ALL on that table to user X.

    When I try to enable a constraint (logged in as user X) on EMP, I am getting ORA-01031: insufficient privileges error.

    Disabling works fine.

    I though having the ALTER privilege on the table should be enough. Any ideas? Thanks.

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Although I'm not condoning this, you may need to grant the 'ALTER ANY TABLE' privilege or possibly 'CREATE ANY INDEX'.
    Last edited by ebrian; 09-06-2006 at 09:28 PM.

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Well...its not a good practise to grant everything u have to another user, u better grant dba to it

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by yxez
    Well...its not a good practise to grant everything u have to another user, u better grant dba to it
    what???? why on earth would you want to grant dba to it

  5. #5
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    I tried this out and it seemed to work for me. Is your "alter privilege" granted directly or through a role ?

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