Re: Schema.table

Excellent!!! Thanks....

In article <39384A9D.E09464A9_at_columbus.rr.com>,   David Grzebien <dgrzebie_at_columbus.rr.com> wrote:
> You can use a PUBLIC SYNONYM. The syntax for this is as follows:
>
> create public synonym table for owner.table;
>
> To create the public synonym, you will need to have DBA privileges in
> the database.
>
> An individual user can create their own private synonyms as well as
 long
> as they have the CREATE SYNONYM privilege granted to them.
>
> Dave
>
> sqlboy_at_my-deja.com wrote:
>
> > Is there a way to get around always having to use the schema.table
> > convention? I know in sql server, if I create all tables as DBO, any
> > user can reference just the table name in a select statement. Does
> > Oracle have a similar functionality?
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jun 03 2000 - 00:00:00 CDT