Home » SQL & PL/SQL » SQL & PL/SQL » schema and user
schema and user [message #443206] Sat, 13 February 2010 12:00 Go to next message
Messages: 202
Registered: April 2006
Senior Member
I have a Schema A
A user B

b has permission to read delete data from schema A.

when a java application gets the connection using B and tries to call a function of schema A i am getting some errors.
now If I get connection using A and call the same function it works no problems ,but a connection with B to call the function fails ,
Please tell me if a non schema user like B tries select or update or call a function on A schema objects (which user B does not own) should the schema prefix be added for every database object ?

Re: schema and user [message #443207 is a reply to message #443206] Sat, 13 February 2010 12:03 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends but as you didn't post any information that will allow us to estimate if in your case it is normal or not we cannot answer.
I bet Oracle is right in its error message that you didn't even tell us what it is.

Previous Topic: Duplicate NULL
Next Topic: call a function which returns multiple values
Goto Forum:

Current Time: Fri Jul 28 00:09:44 CDT 2017

Total time taken to generate the page: 0.16662 seconds