System and Method for SQL Server Resources and Permissions Analysis in Identity Management Systems

2. The identity management system of claim 1, wherein the first identifier and the second identifier is a Security IDentifier (SID).

3. The identity management system of claim 1, wherein the first identifier is associated with a group to which the first identity belongs.

4. The identity management system of claim 3, where at least one of the one or more entitlements is inherited by the first identity through the group.

5. The identity management system of claim 1, wherein a first entitlement of the one or more entitlements is to a first SQL database object and a second entitlement of the one or more entitlements is to a second SQL database object that is a child object of the first SQL database object, and wherein the second entitlement was determined based on the second SQL database object being a child object of the first SQL database object.

6. The identity management system of claim 5, wherein the second entitlement was determined utilizing a SQL permission model.

7. The identity management system of claim 1, wherein the at least one SQL server comprises multiple SQL servers and the one or more entitlements comprises entitlements obtained from each of the multiple SQL servers.

9. The method of claim 8, wherein the first identifier and the second identifier is a Security IDentifier (SID).

10. The method of claim 8, wherein the first identifier is associated with a group to which the first identity belongs.

11. The method of claim 10, where at least one of the one or more entitlements is inherited by the first identity through the group.

12. The method of claim 8, wherein a first entitlement of the one or more entitlements is to a first SQL database object and a second entitlement of the one or more entitlements is to a second SQL database object that is a child object of the first SQL database object, and wherein the second entitlement was determined based on the second SQL database object being a child object of the first SQL database object.

13. The method of claim 12, wherein the second entitlement was determined utilizing a SQL permission model.

14. The method of claim 8, wherein the at least one SQL server comprises multiple SQL servers and the one or more entitlements comprises entitlements obtained from each of the multiple SQL servers.

16. The non-transitory computer readable medium of claim 15, wherein the first identifier and the second identifier is a Security IDentifier (SID).

17. The non-transitory computer readable medium of claim 15, wherein the first identifier is associated with a group to which the first identity belongs.

18. The non-transitory computer readable medium of claim 17, where at least one of the one or more entitlements is inherited by the first identity through the group.

19. The non-transitory computer readable medium of claim 15, wherein a first entitlement of the one or more entitlements is to a first SQL database object and a second entitlement of the one or more entitlements is to a second SQL database object that is a child object of the first SQL database object, and wherein the second entitlement was determined based on the second SQL database object being a child object of the first SQL database object.

20. The non-transitory computer readable medium of claim 19, wherein the second entitlement was determined utilizing a SQL permission model.

21. The non-transitory computer readable medium of claim 15, wherein the at least one SQL server comprises multiple SQL servers and the one or more entitlements comprises entitlements obtained from each of the multiple SQL servers.