Re: Create User and Default Table

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Thu, 14 Oct 1999 21:25:55 GMT
Message-ID: <386a49c7.173297957@netnews.worldnet.att.net>

You probably should look into creating synonyms. Public synonyms affect everybody, private ones affect the user who created them. Log in as user b, and issue this:

        create synonym table for usera.table

Now, as long as user b does not also happen to have a table of the same name, he will be able to do:

        select * from table;

and it will work.

To create a public synonym, so that everyone can use table, log on as SYSTEM, and create the synonym like this:

        create public synonym table for usera.table

Since the PUBLIC keyword was used, the synonym will be usable by everyone.

Note that synonyms do not confer access. You still need to do the grants for that.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Thu, 14 Oct 1999 20:28:44 GMT, tmurrayiii_at_aol.com wrote:

>User B connects to the DB and issues the command:
>
>sql>select * from UserA.table
>
> ....Results here.... (Works just fine)
>
>
>When User B connects to the DB and issues the command:
>
>sql> select * from table.
>Table is not found.
>
>I understand why this fails, but I was wondering if there is a way to
>make USER A's tables the default for User B?
Received on Thu Oct 14 1999 - 16:25:55 CDT