softbless
asked on
Role of A user
Hi Guys,
In my SQL Server, i have Wilson as user. I need to know what is his role.
Could we have SQL syntax to check what role is wilson. Specifically I wanna know whether Wilson has role Sysadmin or not.
Thanks.
In my SQL Server, i have Wilson as user. I need to know what is his role.
Could we have SQL syntax to check what role is wilson. Specifically I wanna know whether Wilson has role Sysadmin or not.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
this means that sa is the SYSADMIN
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Sharath,
The result is :
rolename membername
sysadmin sa
The result is :
rolename membername
sysadmin sa
Can you check if Wilson is available under Security -> Logins?
ASKER
thanks
ASKER
Thanks for the fast response.
Your query return 1 row :
sa SQL_LOGIN SYSADMIN
Does it mean that 'Wilson' is not SYSADMIN?