Shulou(Shulou.com)06/01 Report--

Recently began to learn sybase, the problems encountered in the learning process will be recorded here, I hope to learn with you.

Sybase (ASE) can specify that a script be run automatically to perform the specified action after the user logs in. It is generally a custom stored procedure.

Versions prior to 15.7 adopted

Add: sp_modifylogin my_login, "login script", "scriptName"

Delete: sp_modifylogin my_login, "login script", NULL

Version 15.7 can use the following command:

Add: alter login sa modify login script 'sp_bindlogin'

Delete: alter login sa drop login script

Checking is available with the syslogins table, where the field procid stores login triggers registered with the login script option

For specific stored procedures, please refer to http://tech.cncms.com/shujuku/sybase/67090.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.