Re: How to share a schema with other users?

"Benjamin Lai" <ywlaiben_at_so-net.com.hk> wrote in message news:3D3060DA.BCAF9301_at_so-net.com.hk...
> I have created a number of tables/views using
> a DBA role user. What I want to do is the allow
> other less privleged users to share this schema's
> data. After I granted the select right to
> other users, I found that other users still have to access
> the tables with the schema name before the table name, like
>
> select * from <schema name>.<table name>
>
> Does anybody know if there's any way to simplify this
> troublesome naming scheme? Can I do anything to
> allow other less privileged users to access the tables
> by the table names only?
>
> Any opinion is welcome!
>

You'll need to create private or public synonyms. Please read up on synonyms in your Oracle documentation.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address