• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

What system table is the user-role relationship being stored in SQL Server 2005?

On which system table in SQL Server 2005 can I find the link between the user and database role.   It used to be in sysusers using uid and gid using the old version of sql server.
1 Solution
The sys.sysuers view has the same information as sysusers in SQL Server 2000

You can also get similar information from sys.database_principals
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now