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 -
1> sp_displaylogin esofthub
2> go
For non-privilege roles
# isql -Uesofthub -Panypassword
1> sp_displaylogin
2> go
1 comment:
how to find the logged in time of a particular user.
for example: i have user id(77). I want to get the details of when he is logged in
Post a Comment