Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle-sql-question

Re: oracle-sql-question

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 06 Jul 2004 17:54:38 -0700
Message-ID: <1089161691.252743@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US