Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oacle7 privileges
"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