Re: Read-only DBA-privileges ?

From: Doug Burns <dougburns_at_hotmail.com>
Date: Mon, 21 Feb 2000 10:45:12 GMT
Message-ID: <88r4vn$rsv$1@nnrp1.deja.com>

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 04:45:12 CST