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

From: eugene kim <eugene1977_at_hotmail.com>
Date: Fri, 06 Sep 2002 11:29:00 +0000
Message-ID: <al9a5k$qs9$1@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 - 06:29:00 CDT