Re: sharing same tablespace , can't see table of other user?

Option.

grant select any table to "EACH USER".

EACH USER will have to qualify the other user table as in;

select * from OTHERUSER.TableName;

"eugene kim" <eugene1977_at_hotmail.com> wrote in message news:al9a5k$qs9$1_at_newsreader.mailgate.org...
> hi..
> i need to set up oracle and user accounts for our class group project
> i want users to share one tablespace and have each tablespace(for
 excercise)
>
> now i'm just trying to set up where users can share one tablespace..
>
> here's what i did
> thank you for help
> -------------------------------------------
> CREATE ROLE my_group_role;
>
> grant CREATE SESSION,
> CREATE TABLE,
> CREATE VIEW,
> CREATE TRIGGER,
> CREATE PROCEDURE,
> CREATE SEQUENCE to my_group_role;
>
> CREATE USER user1
> IDENTIFIED BY pass1
> DEFAULT TABLESPACE csi4335
> TEMPORARY TABLESPACE csi4335tmp;
> GRANT connect TO user1;
> grant my_group_role to user1;
> alter user user1 quota 10m on csi4335;
>
> CREATE USER user2
> IDENTIFIED BY pass2
> DEFAULT TABLESPACE csi4335
> TEMPORARY TABLESPACE csi4335tmp;
> GRANT connect TO user2;
> grant my_group_role to user2;
> alter user user2 quota 10m on csi4335;
>
> and i put these in /etc/profile
> ----------------------
> export ORACLE_SID=test
> ORAENV_ASK=NO
> . /usr/local/bin/oraenv
> ----------------------
>
> and created unix-user1 and unix-user2
>
> when unix-user1 connect to my comp, the user can connect to db
> by issuing $sqlplus user1
>
> unix-user2 can connect to db also
>
> however, even though i assigned the same default tablespace, user1 can't
 see
> tables which is created by user2 and vice-versa
>
>
>
>
>
>
Received on Sat Sep 07 2002 - 01:15:32 CDT