Re: Schema.table

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.
Received on Sat Jun 03 2000 - 00:00:00 CDT