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: Oacle7 privileges

Re: Oacle7 privileges

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 14 Sep 2001 12:49:11 +0200
Message-ID: <tq3p1c898d7v6f@news.demon.nl>

"Kennel Yves" <Yves.Kennel_at_DeDietrich.com> wrote in message news:141B66B621DED21195540008C71E3FFB01AC54FA_at_mailhost.acr.dedietrich.com...
> I would like to create a User who has only the privilege of READ
> (select) on the schema of an other user.
> (I would like to maintain it permanent, so the instruction Alter session
> is not adequate).
>
> How can I do that ?
>
> Thanks
>
>

The schema owner needs to grant select privilege on all objects to your user.
You might want to set up a role for this purpose.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 14 2001 - 05:49:11 CDT

Original text of this message

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