-
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.
-
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.
-
Well...its not a good practise to grant everything u have to another user, u better grant dba to it
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|