Re: Grant Rights

In article <dd3da57f.0111301104.1e42ce84_at_posting.google.com>, d.smith_at_ins.hcc.mnscu.edu says...
>
>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
>

select * from user_one.dog;

or

alter session set current_schema=user_one; select * from dog;

or

create synonym dog for user_one.dog;
select * from dog;

>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...
>
>
>--------------------------------------------------------------------------------
>
>
>Terms and Conditions - Posting Style Guide - Posting FAQ

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp