| schema and user [message #443206] |
Sat, 13 February 2010 12:00  |
miroconnect@yahoo.com
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  |
 |
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
|
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.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
