Home » SQL & PL/SQL » SQL & PL/SQL » select access to table from different users
select access to table from different users [message #204070] Fri, 17 November 2006 11:21 Go to next message
Susanne Schneider
Messages: 5
Registered: March 2002
Junior Member
Hello,

I want to create a function in user A where a select statement to a table of user B shall be made. I have grant select, debug and references rights from user A to user B but Oracle still complaints about unsufficient rights.

What to I have to grant to achieve this?
Many thanks for your ideas!
Susanne
Re: select access to table from different users [message #204116 is a reply to message #204070] Fri, 17 November 2006 23:22 Go to previous messageGo to next message
rameshuddaraju
Messages: 69
Registered: June 2005
Location: India
Member

I have grant select, debug and references rights from user A to user B

You are creating a function in User A by getting data from User B
so user B must grant privileges to user A because owner of the table is User B.
Re: select access to table from different users [message #204383 is a reply to message #204116] Mon, 20 November 2006 07:09 Go to previous message
Susanne Schneider
Messages: 5
Registered: March 2002
Junior Member
Thank you for your answer and shure you are right (I meant this direction, sorry for that Embarassed ).
Now it seems to be ok.

Regards,
Susanne
Previous Topic: UTL_MAIL.send: How to put RECORD in MESSAGE
Next Topic: Total newbie to PL/SQL should be an easy one for you gurus.....
Goto Forum:
  


Current Time: Sun Dec 11 04:10:27 CST 2016

Total time taken to generate the page: 0.12359 seconds