Re: Granting Access
Date: Thu, 11 Mar 2004 11:34:45 -0600
Message-ID: <4050A335.5A4549E6_at_ram.lmtas.lmco.com>
Michael Hill wrote:
>
> I granted a user some tables using the following syntax
>
> grant select on project to myuser
>
> When I look at the table privileges using:
>
> select * from table_privileges where grantee = 'myuser'
>
> I can see that "SELECT_PRIV" IS "Y" where "TABLE_NAME" is "PROJECT"
>
> But when I log on as "myuser" and execute:
>
> Select * from project
>
> I get an error message saying "table does not exist".
>
> Is there anything else that needs to be set?
>
> Mike
Never mind I and forgotten to fully quality the table like:
Select * from someserver.project
Here is a good link that talks to this:
http://builder.com.com/5100-6388_14-5054455-2.html
Mike Received on Thu Mar 11 2004 - 18:34:45 CET