Re: Ways to fake table in own scema.

Nope, but if you want to you could make them public synonyms so you don't need to do this for multiple users. There are security issues here though.

HTH. Pete

"G. Mjoen" wrote:

> I have a user (USER1) with a lot of tabes. I created a new user
> (USER2) with no tables in his/hers schema. USER2 is granted select on
> all of USER1's tables.
>
> The problem is:
>
> USER2 needs to write 'select * from USER1.TABLE1' instead of 'select *
> from TABLE1'.
>
> I am able to fix this by creating a synonym for each table. Is there
> som other way of doing this?
>
> --
> Gaute

Received on Fri Aug 27 1999 - 10:47:05 CDT