oracle-sql-question

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 ! Received on Tue Jul 06 2004 - 10:09:26 CDT