|
There are three types of roles in the role-based security model: system roles, user-defined roles (which include user-extended roles), and compatibility roles.
View the roles and privileges a user has in SQL Central by clicking the user and viewing the details that are displayed. You can also retrieve the details using the sp_displayroles system procedure.