OraFAQ Forum: SQL & PL/SQL » Pl/sql query -- grant

Home » SQL & PL/SQL » SQL & PL/SQL » Pl/sql query -- grant (oracle)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Pl/sql query -- grant [message #326183]

Tue, 10 June 2008 09:08

convey05
Messages: 43
Registered: December 2007
Location: CHENNAI

Member

I have two schema's in the same database.
For eg: Database -- test
schema - A and B
I have a table named -testtable in the A Schema for which i have created a view.Synonmyn named SYNA is created on the view.That synonmyn is granted to Schema B.
In the B schema when i queried the Synonym SYNA Like
select * from A.syna it displayed record.
But When i tried to access the same inside the procedure it was throwing error,stating insufficient privilege.
can anyone tellme why it is happening so?
Thanks in Advance

Report message to a moderator