Re: Granting Access

"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 - 17:30:56 CET