Re: how to allow User access to Tables

Mark wrote:

> thanks, but it does not work;
> "select * from cat" results in an empty table
> "select * from scott.cat" results in ORA-00942: table or view not
> existing
>

1. Stop posting questions to which the answers are all obviously and clearly in the documentation. Subtle and complex is fine, but Oracle complete basics are not.
2. Go and read the documentation. http://tahiti.oracle.com is your friend
3. If and only if you've done everything recommended in the documentation and it is still not working, don't just post "it does not work" and your precis of the commands issued and the error messages received: post a cut-and-paste of the relevant SQL*Plus session instead.

The reason that sounds a little harsh, perhaps, is that the advice you've received *does* work. As demonstrated thus:

SQL> create user fred identified by wilma; User created.

SQL> grant create session to fred;
Grant succeeded.

SQL> connect scott/tiger
Connected.

SQL> create table cat(col1 char(5));
Table created.

SQL> grant select on cat to fred;
Grant succeeded.

SQL> connect fred/wilma
Connected.
SQL> select * from scott.cat;

no rows selected

Notice that Fred *does* get to see the table (OK, it has no rows in it, but that's incidental). He does NOT get an ORA-942.

HJR Received on Wed Sep 08 2004 - 05:40:06 CDT