Home Forums SQL Server 2008 SQL Server 2008 Administration Script to get the list of users and permissions in a database RE: Script to get the list of users and permissions in a database

  • April 9, 2014 at 2:42 pm

    #1704693

    as usual, it depends on what you are looking for: object level permissions? ie does user mydomain\lowell have SELECT permissions on HR.dbo.Payroll?

    did you find any script that was close to what you are after so we can use that as a starting point?

    you can get explicitly declared permissions assigned to a user.

    then you need to get any explicitly granted permissions to the role(s) the user belongs to.

    then there what i call implied permissions, which are the permissions that you inherit from fixed database roles/server roles; it's possible that mydomain\lowell is not even an explicit login/user int he database, but comes in via a windows group.

    if you can define what you are after, we can help further.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!