Home » RDBMS Server » Security » Determine locked users from sqlplus? (Oracle 10g 10.2.0.3.0, RHEL 10)
icon5.gif  Determine locked users from sqlplus? [message #407986] Fri, 12 June 2009 13:07 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Determine locked users from sqlplus? [message #407988 is a reply to message #407986] Fri, 12 June 2009 13:48 Go to previous messageGo to next message
Mast
Messages: 5
Registered: June 2009
Junior Member
thank, following your tip i managed to scrounge what i needed.

i know that it's a bad idea to use the SYS/SYSDBA user, but CA ARCSERVE asks for it
Re: Determine locked users from sqlplus? [message #407995 is a reply to message #407988] Fri, 12 June 2009 15:28 Go to previous messageGo to next message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

>>but CA ARCSERVE asks for it

What do you mean by "CA ARCSERVE" ??

Babu
Re: Determine locked users from sqlplus? [message #407997 is a reply to message #407995] Fri, 12 June 2009 15:37 Go to previous messageGo to next message
vamsi kasina
Messages: 2089
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
It seems this.

By
Vamsi
Re: Determine locked users from sqlplus? [message #407999 is a reply to message #407997] Fri, 12 June 2009 16:01 Go to previous message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member


Thank you Vamsi

Babu
Previous Topic: User details - 3 tier application
Next Topic: Cobol program that accesses Oracle database
Goto Forum:
  


Current Time: Sun Apr 20 08:12:55 CDT 2014

Total time taken to generate the page: 0.07346 seconds