Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Read-only DBA-privileges ?
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 - 08:26:12 CST