users cannot see each others tables! Help!

Help! I am new to Oracle, and I'm working on a tight deadline. I have Oracle8. Using sqlplus, I created a tablespace and made it the default tablespace for all my users. I created a role, DEVELOPER, and granted this:

  grant all privileges to DEVELOPER;
  grant CREATE SESSION, CREATE TABLE to DEVELOPER;   grant CREATE SESSION to DEVELOPER;
  grant SELECT ANY TABLE, ALTER ANY TABLE, DROP ANY TABLE,

     INSERT ANY TABLE, DELETE ANY TABLE to BCAMS_DEVELOPER;   grant DBA to DEVELOPER;

My users look like:

CREATE USER ops$susan
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE TSPACE
TEMPORARY TABLESPACE TSPACE
quota 100M on TSPACE;
grant DEVELOPER to ops$susan;

When user 'susan' creates a table, user 'joe' cannot see it. If I query ALL_TABLES, I see the two identical tables, one owned by 'susan' and one owned by 'joe'. Both are in my tablespace TSPACE. The only difference is the owner. How can I create one set of tables for all users to access? I know this must be a stupid question, but I am desperate. I have been reading through piles of docs.

Sarah Officer
officers_at_aries.tucson.saic.com Received on Sat Jun 19 1999 - 20:07:38 CDT