granting rights to types
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: granting rights to types

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    Hello,

    I am trying to create an ap user that just has executable rights to the owner schema's objects. Granting select/execute rights to the objects seems to have worked well (and creating synonyms).

    I have granted the new user execute rights (that is all you can grant) on the types that the schema owner has, and have created synonyms for them too... but we get the error "ORA-04043 " error that it does not exist.

    Do I need to create the types as this other user or can we grant rights to types owned by another user?

    I use Oracle 8.1.6.1.

    Thanks,
    Nirasha
    Nirasha Jaganath

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    You can create but you cannot use synonyms for types. You have to use the schemaname: schema.typename

  3. #3
    Join Date
    Nov 2000
    Posts
    205
    Thanks,

    After going through Oracle forums on metalink, I found:

    "The documentation states that we don't allow synonyms for object types. This can't be changed because synonyms are supposed to be an alias for the table, view, snapshot, sequence, procedure, function or package. "

    Thanks again,
    Nirasha
    Nirasha Jaganath

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