Kbase P85243: How to disconnect a user from the database remotely
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/30/2009 |
|
Status: Verified
GOAL:
How to disconnect a user from the database remotely
GOAL:
How to disconnect a user from the database using a remote machine
GOAL:
Who may disconnect a user from the database.
FACT(s) (Environment):
All Supported Operating Systems
Products / Versions
FIX:
Use proshut command with -S and -H parameters following the steps:
Only the following users are allowed to disconnect database users:
If the database owner, the account that created the database, has administrator/root permissions it can disconnect other users in Promon or using proshut.
The account that started the database can also disconnect other users.
The root account in UNIX or the administrator account in Windows can disconnect other users.
Users can disconnect themselves.
1) Assuming that you database is named "sports2000", the hostname is dbserv and the port number is 6789. Execute proenv script to set the environment variables:
For Windows:
- Go to "Start" button on windows taskbar
- Select "Programs"
- Look for the Progress icons group and Select Proenv.
For Unix or Linux:
- Execute proenv script using the command line:
<progress installation path>/bin/proenv
2) Execute the proshut:
eg: proshut sports2000 -H dbserv -S 6789
This will show the list of users currently connected (if any), and then following menu:
1 Disconnect a User
2 Unconditional Shutdown
x Exit
Enter choice> _
3) Type 1 and hit enter key, you will receive the following prompt:
Enter the user number which is to be disconnected:
4) Type user number and hit enter again.
You should see the user entry clear from the user list
5) Type x to exit.
Please be aware that the database server must be started with the -S option for this to work. The following example assumes that the database server is on a machine named dbserv.
On the server machine:
proserve sports2000 -S 6789