Re: How to share a schema with other users?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 13 Jul 2002 21:06:47 +0100
Message-ID: <3d30890a$2_2@mk-nntp-1.news.uk.worldonline.com>

"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!
>

Hello, Benjamin.

Homework: Search documentation on synonyms. Report your conclusions.

Regards,
Paul Received on Sat Jul 13 2002 - 15:06:47 CDT