Page tree
Skip to end of metadata
Go to start of metadata

Purpose

This content is to propose a way for users to terminate their own sessions.

Overview

Users are unable to terminate their own processes. 

1> kill 15

2> go

Msg 6104, Level 16, State 1:

Server 'repro155', Line 1:

You cannot use KILL to kill your own process.

The Function to terminate the session 

ASE allows DBAs to selectively grant permissions for executing certain commands to specific users or logins by means of the grant statement. However, permissions for executing some commands (like kill) cannot be granted at all, even though this would sometimes be useful.

Function syb_quit allows a client session to terminate itself. 

1> select syb_quit()

2> go

CT-LIBRARY error:

        ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

[sybase@redhead install]$

Related Content

Sybase Adaptive Server Enterprise Reference Manual (Functions)

 

 

  • No labels