Solved

Oracle Web Interface for Password reset

Posted on 2011-03-01
6
302 Views
Last Modified: 2012-05-11
Hi all...

I was wondering if anyone could recommend a password manager with  a web interface for a Oracle environment.  Thanks.
0
Comment
Question by:NYGiantsFan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 35008659
You could build one in APEX without too much difficulty
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35009314
Is this for users, DBAs, ???

dbConsole and/or Enterprise manager Grid Control can do it plus so much more.

If you want to code your own, what languages can you write code in?

ASP.Net is pretty common.
0
 

Author Comment

by:NYGiantsFan
ID: 35016998
It is for DBA's.  They don't wish to write anything.
0
Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

 

Author Comment

by:NYGiantsFan
ID: 35017077
Bascially the problem is that the DBA are locking their accounts and need it reset by an SA.  We want some type of interface that can do this.

Thanks.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35017215
So this is the OS user not an Oracle database user?

What OS?

I assume account locking is taking place because of some internal security mandate.  If so, will some 'open' GUI that allows elevated privs to 'unlock' the account not violate those rules?

If there are no rules for this, why not just set the account to not lock on failed attempts?
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 35017336
if it's going to be something relatively automatic, just use a simple script, no web interface needed.

have the sysadmins create a script that resets the dba password and then logs off
put that script in the startup of some dummy user.

then, if the dba's lock their account, they simply log in to the dummy account and their dba account will get unlocked.

or create an automated job that unlocks the account every 10 minutes.

I do agree with slightwv that any method of easy password resets needs to be examined to see if it's really appropriate to do so.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question