How to disable sql login [message #555742] |
Mon, 28 May 2012 02:44 |
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.
|
|
|
|
|