Granting Access

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Thu, 11 Mar 2004 10:10:25 -0600
Message-ID: <40508F71.75D88A9E@ram.lmtas.lmco.com>

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 Received on Thu Mar 11 2004 - 10:10:25 CST