Just because something is in the same tablespace does not make it visible to
others. What you are seeing is that if you aren't the owner of the object
(creator) then you might not be able to see it.
Jim
"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 Fri Sep 06 2002 - 00:08:18 CDT
