Home » RDBMS Server » Security » How to disable sql login (Oracle 10g, 10.2.0.4.0 on AIX 5.3)
How to disable sql login [message #555742] Mon, 28 May 2012 02:44 Go to next message
raj9999
Messages: 49
Registered: June 2011
Member
How to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".

Is it possible? If no, then what can be done to achieve below.

I have a userid which has all the update, delete privileges on it. That id needs to be configured in the application alongwith the password. So in order to avoid misuse of that id I want to block its sql access.

I am not sure whether this can be achieved or not. Kindly help.
Re: How to disable sql login [message #555744 is a reply to message #555742] Mon, 28 May 2012 02:59 Go to previous messageGo to next message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See whether this previous discussion helps. Search the board for more results (if any).
Re: How to disable sql login [message #555776 is a reply to message #555744] Mon, 28 May 2012 13:46 Go to previous message
Flyby
Messages: 139
Registered: March 2011
Location: Belgium
Senior Member
proxy logins?Configuring Oracle Database Proxy Authentication
Previous Topic: Applying Critical Patch Update
Next Topic: Audit specific statment on specific table by specific user
Goto Forum:
  


Current Time: Sun Apr 20 04:09:20 CDT 2014

Total time taken to generate the page: 0.07842 seconds