| Kick out users on 10g? [message #602586] |
Thu, 05 December 2013 15:24  |
 |
RM33
Messages: 11
Registered: December 2013
Location: New York City
|
Junior Member |
|
|
Sorry for the double post. I am not sure in which section to put this question. So it is in Windows also.
We are using 10g, HP Unix and VB.Net.
I have been tasked with creating a user interface written in Visual Basic. Why VB? Because it is the standard here.
In the past, they had Korn Shell scripts that disabled users accounts, kicked out logged in users, did maintenance and other things on Oracle, then allow the users back in.
My question is can I write a stored procedure or trigger something on Oracle that kicks out the users. I have to do this from a Visual Basic interface. To sum up, from a VB GUI front end, I need to kick out users, do maintenance, then allow them back in.
So can VB trigger someting in Oracle to kick out users?
[Updated on: Thu, 05 December 2013 15:29] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: Kick out users on 10g? [message #602644 is a reply to message #602586] |
Fri, 06 December 2013 04:36  |
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
|
Senior Member |
|
|
To add to the other answers, have a look at the following commands:
"alter system kill session" and "alter system disconnect session" (look it up in the docu  )
Also, as Michel Cadot suggested, you can alter the sytem to only acceptd users with restricted session privileges.
However this will not kick the exisiting users out. You still have to provide for that.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
