Home » RDBMS Server » Security » Grant Problem
Grant Problem [message #1426] Mon, 29 April 2002 14:33 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Install 9i Startup Password?
Next Topic: password problem
Goto Forum:
  


Current Time: Thu May 26 14:58:58 CDT 2022