The sp_displaylogin reports information on a login in Sybase. It gives detailed information such as, user identification, full name, roles, and account status. Here is its syntax.
For privilege roles
This example provides information about a privileged user.
# isql -Usa -Ppassword
1> sp_displaylogin esofthub
2> go
For non-privilege roles
This example provides information about a user’s own login.
# isql -Uesofthub -Panypassword
1> sp_displaylogin
2> go