Home » RDBMS Server » Server Administration » Kick out users on 10g?
Kick out users on 10g? [message #602586] Thu, 05 December 2013 15:24 Go to next message
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 #602591 is a reply to message #602586] Thu, 05 December 2013 15:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Oracle does not know or care about the "flavor" of the client.
EVERYTHING that changes the content of the database must be done via SQL statements
Re: Kick out users on 10g? [message #602595 is a reply to message #602591] Thu, 05 December 2013 18:29 Go to previous messageGo to next message
RM33
Messages: 11
Registered: December 2013
Location: New York City
Junior Member

Thanks for the reply.

So everything can be done via SQL Statements?

So how then do you kick out the users who are logged on the database?
Re: Kick out users on 10g? [message #602596 is a reply to message #602595] Thu, 05 December 2013 18:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_2016.htm#SQLRF53165
Re: Kick out users on 10g? [message #602628 is a reply to message #602586] Fri, 06 December 2013 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator


Quote:
I need to kick out users, do maintenance, then allow them back in.


RESTRICTED SESSION mode is made to not allow standard users to connect during maintenance.

Re: Kick out users on 10g? [message #602644 is a reply to message #602586] Fri, 06 December 2013 04:36 Go to previous message
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 Smile)

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.

Previous Topic: Disabling SQL Tuning Advisor
Next Topic: To provide privilege on utlrp.sql to users
Goto Forum:
  


Current Time: Thu Mar 28 19:28:55 CDT 2024