| Privileges on table [message #162066] |
Wed, 08 March 2006 09:39  |
chandanbhamra
Messages: 84
Registered: April 2005
Location: India
|
Member |
|
|
I have two users A and B. User A owns table T1 and i grant privileges insert,select,update,delete on T1 to user B. User B is able to make select,insert,update,delete but when i write stored procedure and make use of table T1 by specifying A.T1 then it says Table or View does not exist. I made one synonym T1 on that i.e. A.T1 but again when i refer to that synonym in my stored procedure it says Table or View does not exist.
One thing is that there are some tables in User A which i am able to refer in my SP made in user B after making synonym's in user B.
I don't know why i am facing this problem on few selected tables. I have checked it, T1 is a table in user A.
Please anybody can suggest me why this problem is coming ??
Thanks in advance
Chandan Singh
|
|
|
|
| Re: Privileges on table [message #162068 is a reply to message #162066] |
Wed, 08 March 2006 09:43  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
did you grant those privileges via roles?
If so, it may be the problem. Priviliges granted via role will not be seen in pl/sql.
Grant the priviliges directly.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
