Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle-sql-question
freak wrote:
> hi
> i'm quite new to oracle and i found out, that if i have some tables
> containing data under the schema SYSTEM i can assign users to see that
> tables.
> in an slq-query, unfortunately, i have to write kind of a path to find
> the data i need, eg
>
> select * from SYSTEM.Tabelle_1 where ID = '2'
>
> now my question:
> is there a way to have the tables under SYSTEM, assign users to see
> the data under SYSTEM by giving them the select-right, without having
> to write the SYSTEM in the query, but ony
> select * from Tabelle_1 where ID = '2' ?
>
> any help would be nice !
CREATE SYNONYM xyz FOR system.tabelle_1;
SELECT * FROM xyz;
Daniel Morgan Received on Tue Jul 06 2004 - 19:54:38 CDT