Re: Granting Access

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
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

Original text of this message