Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004

    Unanswered: insufficient privileges while being sysdba ??

    Hi there !

    I have an Oracle 9iR2 server, and the following issue:

    I can not make a foreign key constraint from a table in a schema to a table in an other schema ; I get the "ORA-01031: insufficient privileges"

    Even if I run the command as SYSDBA ! As far as I know, SYSDBA is God, so there should not be any privileges question.

    Can you help me ?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >As far as I know, SYSDBA is God, so there should not be any privileges question.
    Well, obviously you thought wrong.
    Appropriate GRANT(s) will eliminate the error message.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2004
    In 9i you can grant permission on behalf of others. However, if you are attempting to create a foreign key on behalf of someone else the permission must be granted to that schema prior to foreign key being created.

  4. #4
    Join Date
    Jul 2003
    JimYoo is correct.

    In other words:
    User SCOTT must have permissions to create a trigger if (as SYS) you
    attempt to create a trigger OWNED by SCOTT.

    ie: create or replace trigger scott.MY_TRIGGER ...
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts