Re: Changing the default schema for a user

"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> a écrit dans le message news: bq9ui1$20fvn8$1_at_ID-82536.news.uni-berlin.de...
>
> >
> > "Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> a écrit dans le message de
> > news: bphpqp$1ohjv8$1_at_ID-82536.news.uni-berlin.de...
> >>
> >> > Greetings All,
> >> >
> >> > I have created a oracle instance in ORACLE 9i.
> >> > I have created a user "admin" and create a lot of tables and object
> >> > belongs to user "admin". And now, I need to create another user
> >> > "operator" who just only can SELECT, INSERT, UPDATE and DELETE on all
> >> > tables of schema "admin".
> >> >
> >> > Therefore, I grant SELECT, INSERT, UPDATE and DELETE of all objects
> >> > under "admin" to "operator" and using the following command when
> >> > "operator" login:
> >> >
> >> > ALTER SESSION SET CURRENT_SCHEMA= admin;
> >> >
> >> > it is successfully the "operator" operate on all tables of "admin"
but
> >> > cannot ALTER tables, but it is very trouble that everyone login as
> >> > "operator" needs to ALTER SESSION. Can I change the "operator"
login's
> >> > default schema as "admin"!?
> >> > or is there any other methods to solve my scenario, e.g. synonym (I
> >> > don't know how to use synonym) !?
> >> >
> >> > Thomas Lam
> >>
> >>
> >> Additionally -besides the two mentioned methods- you can of course
> >> qualify the tables with the schema.object notation like so:
> >>
> >> select * from admin.table_name where bla='foo';
> >>
> >>
> >> Also, operator is a reserved word and I'd refrain from using it as a
> >> user's name:
> >>
> >> select * from v$reserved_words where keyword='OPERATOR'
> >>
> >>
> >> hth,
> >> Rene
> >>
> >>
> >> --
> >> Rene Nyffenegger
> >> http://www.adp-gmbh.ch
> >
> > Well spotted, Rene.
> > Guess you're from Switzerland, am i right ?
> > People there are wellknown for their accuracy.
>
>
> Yes, I am swiss. Don't know if that makes me any more accurate as anyone
> else, though.
>
> Rene
>
>
> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch

Nevermind, it was just an attempt to be funny . . . I was refering William Tell's famous way to slice apples.

Cheers
Alkos Received on Mon Dec 01 2003 - 04:26:38 CST