Jump to content
Pratik

How to check if login is disabled for application users on oracle DB

Recommended Posts

Ericsson switch application has end users on application and they are open on oracle database however i have been told no user including DBA can login on database. Any change is made through packages. How do i check this setting? Please help urgently

Share this post


Link to post
Share on other sites

Hi Pratik, and welcome to the forum!

i have never used the Erickson application, but there is no way to disable Oracle logins unless there were too many password attempts.

you cannot login via sqlplus?

You can also lock and unlock users with these commands:

http://www.dba-oracle.com/t_passwords_locking_changing_expiring.htm

http://www.dba-oracle.com/concepts/alter_users.htmI

I would contact the application vendor for support.

Good luck!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×