Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Grants Rights
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;
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... Received on Fri Nov 30 2001 - 13:02:31 CST