Skip to Content
24x7 Support
Email: mail@example.com
Call Us +(21) 1234 5678

    • Home
    • MSSQL
      • SQL On Linux
      • T-SQL Scripts
    • Sybase ASE
      • Sybase Scripts
    • Sybase Replication
    • Sybase IQ
    • Linux
    • Search for:

    Tag Archives: Sybase Login

    1. Home  - 
    2. Posts tagged "Sybase Login"
    7 Nov, 2021
    Locked login list status in Sybase ASE 0 (0)
    Sybase ASE Sybase Login

    Below query can be used to check list of locked out logins in Sybase database server.

    select @@servername "Server", name,lockdate from master..syslogins where status&2=2

    Sample output:

    … Read the rest
    31 Oct, 2021
    How to get all the logins with sa_role in Sybase database 5 (2)
    Sybase ASE sa role, Sybase Login

    Below query can be used to get all the logins having sa role in Sybase database.

    select @@servername,l.name,l.fullname,u.name from syslogins as l,sysroles as r,sysloginroles as sr,sysusers as u where l.suid=sr.suid and u.uid=r.lrid and r.id=sr.srid and srid = 0

    Sample output… Read the rest

    Recent Posts
    • SQL Server: T-SQL Script to find object level permission of specific table
    • SQL Server: T-SQL Script to find object level permission of user database
    • T-SQL Script to get user with DB OWNER role in SQL Server
    • T-SQL script to list all database user access in SQL Server
    • T-SQL script to find active processes in SQL Server

    Pages

    • About Me
    • Contact
    • Disclaimer
    • Privacy Policy

    Categories

    • Linux (8)
    • MSSQL (75)
      • SQL On Linux (15)
      • T-SQL Scripts (19)
    • Sybase ASE (26)
      • Sybase Scripts (1)
    • Sybase IQ (3)
    • Sybase Replication (27)
    • Uncategorized (1)

    Archives

    Copyright © 2026 | Powered by Neom