Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Granting sysoper privilege
<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