Forum Discussion

Swoop's avatar
Swoop
Frequent Contributor
12 years ago

Need to determine all security administrators for all projects

As a Security Administrator, I do not have visibility into several projects.  Via the database, what is the query to view all security administrators for all projects?
  • Swoop's avatar
    Swoop
    Frequent Contributor
    The reply from support didnt provide me with what I requested, so I came up with this query, which seemed to do the trick.  (22427 was what SecurityAdmin evaluated to in the SecurityGroups table)



    SELECT Persons.FirstName + ' ' + Persons.LastName AS SecurityAdmin, Projects.ProjName

    FROM PersonSecurityGroups, Projects, Persons

    WHERE SecurityGroupId=22427

    AND PersonSecurityGroups.ProjId=Projects.ProjId

    AND PersonSecurityGroups.UserId=Persons.UserId

    ORDER BY ProjName ASC