What is the difference between User and Role in SQL Server? RRS feed

All replies

  • Hello,

    A login is a server principal and can logon to SQL Server, a database user is an associated login with permissions to access the database and a role is an organization unit for permissions; a database user can be member of 1 - n database roles.

    See for example: Basic SQL Server Security concepts – logins, users, and principals

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, November 7, 2016 5:19 PM
  • Thanks!
    Tuesday, November 8, 2016 9:31 PM
  • Hi dNikhil,

    Does the post given from Olaf help you? If you are satisfied with this solution, could you please mark his reply as "Answered"? I think this will help other community members reading this thread.

    Best Regards,

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Thursday, November 10, 2016 1:34 AM