Re: Newbie:Including other users in my own schema

Hi Cyril:

First, be sure to:
-grant rights on 'creator' tables to 'others users'. -grant 'alter session' to 'others users'.

When you connect as 'others users':
alter session set current_schema=creator

Now you can work with 'creator' tables without prefixing the tables with the schema.

Aaaaaaaadios,

Javier Rojas

Cyril Elkaim wrote:

> Hi,
>
> Is it possible to intern other users in my own schema. That is, for the
> other users, assuming I grant them rights on my tables, to select,
> etc... without prefixing the name of my tables with my schema?
>
> creator:
> create table test (...)
> grant all on test to other
> other:
> select * from test
> and not:
> select * from creator.test
>
> The reason is that I must modify many, many queries in my application
> and I really prefer to avoid that :-)
>
> Thanks
> Cyril Elkaim
Received on Fri May 21 1999 - 04:11:34 CDT