Home » SQL & PL/SQL » SQL & PL/SQL » Pl/sql query -- grant (oracle)
Pl/sql query -- grant [message #326183] Tue, 10 June 2008 09:08 Go to next message
Messages: 43
Registered: December 2007
Location: CHENNAI
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
Re: Pl/sql query -- grant [message #326186 is a reply to message #326183] Tue, 10 June 2008 09:14 Go to previous messageGo to next message
Messages: 25542
Registered: January 2009
Location: SoCal
Senior Member
Privileges acquired via ROLE do not apply within PL/SQL procedures
Re: Pl/sql query -- grant [message #326190 is a reply to message #326183] Tue, 10 June 2008 09:33 Go to previous message
Michel Cadot
Messages: 65088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do I get a "ORA-01031: insufficient privileges" or "PLS-00201: identifier 'x' must be declared" in my stored procedures?

Previous Topic: Problem: The moment snapshot is get refreshed a message should be printed
Next Topic: 32,000 chars + into BLOB
Goto Forum:

Current Time: Wed Jul 26 18:08:12 CDT 2017

Total time taken to generate the page: 0.18402 seconds