Re: oracle-sql-question

On 6 Jul 2004 08:09:26 -0700, blx999_at_gmx.de (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 !

First of all: never ever create your own tables under SYSTEM Secondly: look up the CREATE SYNONYM command in the Sql reference manual.

--
Sybrand Bakker, Senior Oracle DBA