(Windows only) Displays all roles granted to Windows NT users and groups with sp_grantlogin.
sp_logininfo ["login_name" | "group_name"]
is the network login name of the Windows NT user.
is the Windows NT group name.
Displays the permissions granted to the Windows NT user “regularjoe”:
sp_logininfo regularjoe
account name mapped login name type privilege --------------- ------------------ --------------- -------------- HAZE\regularjoe HAZE_regularjoe user 'oper_role'
Displays all permissions that were granted to Windows NT users and groups with sp_grantlogin:
sp_logininfo
account name mapped login name type privilege --------------- ------------------- ------------ ------------ BUILTIN\Administrators BUILTIN\Administrators group 'sa_role sso_role oper_role sybase_ts_role navigator_role replication_role' HAZE\regularjoe HAZE_regularjoe user 'oper_role' PCSRE\randy PCSRE_alexander user 'default'
sp_logininfo displays all roles granted to Windows NT users and groups with sp_grantlogin.
You can omit the domain name and domain separator
(\) when specifying the
Windows NT user name or group name.
The permission checks for sp_logininfo differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage roles privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. |
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_displaylogin, sp_grantlogin, sp_revokelogin, sp_role, sp_who
