Re: Ways to fake table in own scema.

We had the same problem with a 4GL tool. We did the following:

1. We ran a script by USER1 that generated commands like 'grant select on USER1.xxx to USER2;' like you did. This generated script was to be run by USER1.
2. We ran a script by USER1 that generated commands like 'create synonym xxx for USER1.xxx;'. The generated script had to be run by USER2.

After that, we could do a "describe xxx" by USER2 without any security holes.

Even better, the 4GL tool was not able to issue a "drop table xxx" or "drop view xxx" successfully.

Martin

"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 Sun Sep 05 1999 - 04:11:37 CDT