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

Thread: Creating DB proc

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    Are there any restrictions on creating a db procedure using a synonym for a table which is present in the other user?
    I am getting an error,
    8/1 PL/SQL: SQL Statement ignored
    8/55 PLS-00201: identifier 'STRK2.USER_AGENT' must be declared


    where strk2.user_agent is a table(name user_agent) in user strk2, for which the synonym is user_agent

    can you help
    Badrinath


  2. #2
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    You don't have privileges on that table. That is why you are getting that error. Check the privileges.

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    I have all the privilages, I am able to select from this tables, but I am not able to create a view or create a procedure based on this table on the other schema(strk2)
    badrinath

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Do you get the privileges from a role or are they directly granted to you?
    Jeff Hunter

  5. #5
    Join Date
    Jan 2001
    Posts
    642
    I GET IT FROM ROLE.
    WHAT DIFF DOES IT MAKE TO GET IT FROM ROLE OR DIRECTLY
    Pl explain
    Badrinath

  6. #6
    Join Date
    Jan 2001
    Posts
    642
    How different is it that grants given through role compared to direct grant
    Badrinath

  7. #7
    Join Date
    Nov 2000
    Posts
    344
    privileges granted through a role are not visible from stored procedures, functions, packages, etc.

    if they are granted directly then they are visible from them.

    It's a silly rule that Oracle has given us (IMHO), but we have to live with it.

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