Re: Granting sysoper privilege

From: <sybrandb_at_yahoo.com>
Date: 28 May 2003 00:25:50 -0700
Message-ID: <a1d154f4.0305272325.6a834677@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?

Regards

Sybrand Bakker
Senior Oracle DBA Received on Wed May 28 2003 - 02:25:50 CDT