Child pages
  • List Users with SYSDBA privileges

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Generate list of users with SYSOPER or SYSDBA privileges

...

SQL> select * from V$PWFILE_USERS;
USERNAME                       SYSDB SYSOP

...


------------------------------ ----- -----

...


SYS                            TRUE  TRUE
SYSTEM                         FALSE TRUE
ENG001                         FALSE TRUE