Failing to access the objects in other schema thru procedures [message #418449] |
Sat, 15 August 2009 10:56  |
athene
Messages: 11 Registered: January 2009
|
Junior Member |
|
|
Hi All,
We are creating a stored procedure (in userA) which tries to access a table in a different user (say B).The user A has select privilege on user B tables and we are able to run select queries as well.
But when trying to access the same in the procedue it throws an error PLS-00201: identifier '<USER B>.<TABLE_NAME> must be declared.
Can you please help us.It is very urgent.
Thanks in Advance.
Athene.
|
|
|
|
|
|
|