Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Changing the default schema for a user

Re: Changing the default schema for a user

From: Alkos <rtd45Rd_at_nospam.org>
Date: Thu, 20 Nov 2003 21:38:38 +0100
Message-ID: <bpj8o7$5bm$1@news-reader2.wanadoo.fr>

"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.

Cheers,
Alkos Received on Thu Nov 20 2003 - 14:38:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US