Re: users cannot see each others tables! Help!

You can do one of several things:
1) Joe can qualify his access: SELECT * FROM SUSAN.TABLE_1 2) Joe can one time: CREATE SYNONYM TABLE_1 for SUSAN.TABLE_1 and from then on: SELECT * FROM TABLE_1
3) The DBA can one time: CREATE PUBLIC SYNONYM TABLE_1 for SUSAN.TABLE_1 and from then on all users can just SELECT * FROM TABLE_1

GRANT's only give permission. SYNONYM's make the ownership transparent. For your purposes, you need both.

Sarah Officer wrote:

> 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 - 21:22:55 CDT