Re: tables and tablespaces

as SYSTEM you have to execute:
grant select on test to u;

then user u can reference system table test: select * from system.test;

if you don't want to prefix table name with table owner you have to create a public synonym:
create public synonym test for system.test;

then user u can reference the table with: select * from test;
(if u is not owner of a table or a view named test)

--
Michel

Leif Kuschel <Leif.Kuschel_at_t-online.de> a écrit dans le message : 87s1qu$fioe$1_at_fu-berlin.de...
> Hello all,
>
> here my question ( I hope the last for today :-) ).
>
> Following situation:
>
> I have a user (u) with properties
>
> default Tablespace: x
> temporary Tablespace: SYSTEM
>
> and the privilege
>
> Admin Option
> ALTER SESSION no
> CREATE DATABASE LINK no
> CREATE PROCEDURE no
> CREATE SESSION no
> CREATE SYNONYM no
> CREATE TABLE no
> CREATE VIEW no
>
> I created a table in the tablespace SYSTEM like "test" as user "system".
>
> Now the user (u) must select the table "test". What I have to do ?
> Is it possible or not ?
>
> thanks, Leif
>
>
>
>
Received on Wed Feb 09 2000 - 10:07:38 CST