Re: Granting Access

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 11 Mar 2004 11:30:56 -0500
Message-ID: <wpadnZ60ePLQCc3d4p2dnA@comcast.com>

"Michael Hill" <hillmw_at_ram.lmtas.lmco.com> wrote in message news: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

'myuser' needs reference the table owner as well as the name, ie select otheraccount.project -- kinda like referencing the directory path of a file if you're not in the file's directory

;-{ mcs Received on Thu Mar 11 2004 - 10:30:56 CST