Re: Grants Rights

"doug" <d.smith_at_ins.hcc.mnscu.edu> wrote in message news:dd3da57f.0111301102.41b47b37_at_posting.google.com...
> I need some help here! I've been using MYSQL and Postgres for quite
> awhile and have not had this problem before. With Oracle9i I can not
> get my users to be able to see each others tables.
>
> As user_one:
>
> create table dog
> (id number(2));
> Grant all on dog to user_two;
>
> insert into dog(id) values('2');
>
> select * from dog;
>
> ----
> id
> ----
> 2
>
> exit
>
> sqlplus user_two/<password>
>
> sql>select * from tab;
> no rows selected.
>
> sql>select * from dog;
> ORA-00942: table or view does not exist
>
> I should also point out I created the users as system/<password>
>
> create user user_one identified by <password>
> grant connect, resource to user_one;
>
> created both isers the same way.
>
> I realize this is over simplistic but I'm going nuts here!
>
> HELP!!!!
>
> Thankx in advnace doug...

Yes it is an indication you need to RTFM. You either need to prefix the table name with the owner, or you need to create private or public synonym.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address