Determine locked users from sqlplus? [message #407986] |
Fri, 12 June 2009 13:07  |
Mast
Messages: 5 Registered: June 2009
|
Junior Member |
|
|
How can i determine from SQLPLUS if a specific user is locked?
i have a user with SYSDBA equivalence and want to determine is "USERB" is locked(i don't have userb password of course)
i tried with:
select * from v$pwfile_users;
but returns empty,
any ideas?
|
|
|
Re: Determine locked users from sqlplus? [message #407987 is a reply to message #407986] |
Fri, 12 June 2009 13:12   |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
dba_users.account_status
- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.
NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.
Regards
Michel
[Updated on: Fri, 12 June 2009 13:13] Report message to a moderator
|
|
|
|
|
|
|