Re: Read-only DBA-privileges ?

Sorry, that should have been SELECT_CATALOG_ROLE role ..

Doug

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.
> >
>
> 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 - 06:28:51 CST