| grant problems [message #197906] |
Fri, 13 October 2006 04:31  |
user82
Messages: 49
Registered: June 2006
Location: Romania
|
Member |
|
|
I have the following situation: I have an application and at a moment i need to give some grants to a user,through the application...
The user logs on "TEST" schema, this schema has DBA role...the grant is : "GRANT SELECT ON mmm.NBANK TO ROLE_mmm_OBJ" . 'mmm' user exists and also the 'NBANK' table exists in mmm's schema, and i get the following error: ORA-00942: table or view does not exist
If I try that grant under SQL*Plus(also logged as TEST) it successfully works...Can anyone give me a hint to this problem, please???
[Updated on: Fri, 13 October 2006 06:52] Report message to a moderator |
|
|
|
| Re: grant problems [message #197921 is a reply to message #197906] |
Fri, 13 October 2006 04:57  |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Are you sure that this statement works through PL/SQL? Did you, perhaps, mean to say "through SQL"?
DBA is a role; privileges given directly to the user will be fine, but those given through roles will not be seen. In other words, SQL statement will work in SQL*Plus, but not in PL/SQL.
What to do? Grant required privileges directly to the user, or - if possible - move all tables into one schema. One more option would be defining procedures you use with invoker rights.
However, if this is not the point here, hmmm ... 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
