Re: Read-only DBA-privileges ?

You could try granting select on the various views to the user. Since the views are owned by SYS, you might need to log in as SYS to do the grant.

On Mon, 21 Feb 2000 14:26:12 GMT, Morten Lange ISL <mortenlange_at_my-deja.com> wrote:

>Hi Doug,
>
>In article <88rb22$vfb$1_at_nnrp1.deja.com>,
> Doug Burns <dougburns_at_hotmail.com> wrote:
>> Sorry, that should have been SELECT_CATALOG_ROLE role ..
>>
>> Doug
>>
>
>OK. Great ! Then it seems that this can be done in version 8.
>We're using 7.3.4, (8.1 on some servers, but not the one in question ... yet)
>
>
>Thanks and Best Regards,
>Morten
>
>
>
>> In article <88r4vn$rsv$1_at_nnrp1.deja.com>,
>> Doug Burns <dougburns_at_hotmail.com> wrote:
>> > What version are you running?
>> >
>> > You could try granting SELECT_CATALOG role to the user, but I think
>> this
>> > might be V8-specific.
>> >
>> > Cheers,
>> >
>> > Doug Burns
>> >
>> > In article <88r2fb$q29$1_at_nnrp1.deja.com>,
>> > Morten Lange ISL <mortenlange_at_my-deja.com> wrote:
>> > > Hi,
>> > >
>> > > I need to let a user (unix-admin) be able to access various
>> v$process,
>> > > v$session, v$sqltext and others, without granting write access to
>> > anything in
>> > > Oracle (except perhaps private tables). Is this possible at all,
>> > preferably
>> > > compatible with making sql -requests from within svrmgrl (or if need
>> > be
>> > > sqlplus)
>> > >
>> > > TIA,
>> > > Morten Lange
>> > > (If I receive any email answers I'll summarize)
>> > >
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Feb 21 2000 - 16:27:38 CST