Re: How to share a schema with other users?

Thanks for your hint Paul, my findings are listed in my reply to Sybrand's message.

Paul Brewer wrote:

> "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 Sun Jul 14 2002 - 01:20:15 CDT