Solved

Oracle Web Interface for Password reset

Posted on 2011-03-01
6
298 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

739 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