| Oracle User Management [message #526532] |
Tue, 11 October 2011 08:46  |
 |
tonyry
Messages: 4
Registered: October 2011
|
Junior Member |
|
|
I'm looking for a basic password reset/unlock tool for use at a helpdesk. Environment is mixed 10 and 11G. Current procedure is log into specific database using SQL Plus and manually type out reset/unlock commands.
Any assistance locating an application, vbscript, etc. to do this is greatly appreciated!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle User Management [message #526846 is a reply to message #526576] |
Thu, 13 October 2011 05:41  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Here's a small Excel worksheet that will give you a start for an application.
The worksheet contains 2 sheets. The first one let you give your credentials (user, password and "base" which is the tnsnames alias for your target instance) and connect clicking on the "Connect" button.
Once you are connected, the second sheet is activated with the list of the Oracle accounts, their status, lock and expire dates.
You can select one or several accounts double-clicking in the "Select" column then you can lock, unlock or change the password of these accounts clicking on the "Lock", "Unlock" or "Change Psw" button.
There also is a "Refresh" button that allows you to refresh the information in the sheet.
For this version, you need the DBA privileges (actually SELECT on DBA_USERS and ALTER USER privileges are sufficient). If have not these ones, ask your DBA to create a view similar to the SELECT query inside the worksheet and a package with LOCK, UNLOCK and CHANGE_PSW functions and grant you the EXECUTE privilege on this package to allow you to make these actions.
This worksheet works with OO4O (Oracle Object for OLE), you have to install it from the Oracle client CD.
Regards
Michel
[Edit: program slighty modified to fix a display bug]
[Updated on: Fri, 14 October 2011 08:31] Report message to a moderator |
|
|
|
| Re: Oracle User Management [message #527016 is a reply to message #526846] |
Fri, 14 October 2011 08:23 |
|
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Here's another solution; about the same one but with no need of powerfull privileges.
Ask your DBA to execute the SQL script and grant you SELECT privilege on the created view and EXECUTE privilege on the created package.
Then you can use the Excel worksheet (same interface than the previous one).
Regards
Michel
[Edit: put privilege name in upper case]
[Updated on: Fri, 14 October 2011 14:34] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
