| Grant Problem [message #1426] |
Mon, 29 April 2002 14:33  |
Eric
Messages: 78
Registered: April 1999
|
Member |
|
|
Hi,
I have granted select privilege to one user on one table from another schema but it doesn't work. It says "table or view doesn't exist".
It's strange because I can see the grant was effectively done but even though it doesn't work.
Can anybody give some assistance on this?
I would really aprreciate your help.
Thanks,
eric.
|
|
|
|
| Re: Grant Problem [message #1427 is a reply to message #1426] |
Mon, 29 April 2002 17:03  |
K. Balasubramanian
Messages: 10
Registered: April 2002
|
Junior Member |
|
|
Hai,
Please create a public synonym for the table from which u have created and try. the command is
example table is emp create by owner Bala
create public synonym emp for bala.emp
Try this and tell me
Bye
From
K. Bala
|
|
|
|
| Re: Grant Problem [message #1435 is a reply to message #1426] |
Tue, 30 April 2002 07:17 |
Eric
Messages: 78
Registered: April 1999
|
Member |
|
|
Hi,
That was the problem. I had looked for synonyms for that table with no success. But now I found it. There was a set of tables without synonyms. Now I have created them all.
Thanks a lot.
Eric
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
