Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Granting sysoper privilege

Re: Granting sysoper privilege

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 28 May 2003 22:33:37 +1000
Message-ID: <3ed4aca3@dnews.tpgi.com.au>


<sybrandb_at_yahoo.com> wrote in message
news:a1d154f4.0305272325.6a834677_at_posting.google.com...
> Peter <peter_at_nomorenewsspammin.ca> wrote in message
news:<3sm7dv08ahsi91l2dca05vfsc7qtcmgbcv_at_4ax.com>...
> > I granted the SYSOPER privilege to a user
> > but
> > select * from dba_sys_privs;
> > and
> > select * from user_sys_privs;
> >
> > did not show that the user had that privilege.
> > Did I use the right data dictionary?
> > Thanks
>
> No.
> Check out v$pwfile_users.
> Question for you: are you getting paid for asking RTFM questions in
> order to bore and annoy this forum? Or are you just lazy?

It's getting a bit silly, I agree.

Regards
HJR Received on Wed May 28 2003 - 07:33:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US