Granting Access
From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Thu, 11 Mar 2004 10:10:25 -0600
Message-ID: <40508F71.75D88A9E_at_ram.lmtas.lmco.com>
Date: Thu, 11 Mar 2004 10:10:25 -0600
Message-ID: <40508F71.75D88A9E_at_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