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
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
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
BlackSwan
Messages: 26766
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: 68761
Registered: March 2007
Location: Saint-Maur, France, https...
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?

Regards
Michel
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: Sat Jul 12 04:36:48 CDT 2025