Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    79

    Unanswered: Synonyms in Oracle-

    Says insufficient privileges:

    SQL> CREATE PUBLIC SYNONYM abc FOR myTable;
    CREATE PUBLIC SYNONYM abcFOR myTable
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges


    Please help!
    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Because you do not have CREATE PUBLIC SYNONYM Privillege.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Feb 2004
    Posts
    79
    how can i get the permsisions level to create synonyms..
    i am supposed to create all this stuff
    thanks

Posting Permissions

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