I have a large DB product running under MS SQL 2005 on windows server 2003 SP2.
I have problems with the uninformed changing permission on objects.
I need to build a SP that correctly sets the permissions of objects.
I need to iterate over objects ( SP and DB tables ), read off the roles for those objects and compare them with a list I have of what roles should be attached to that object .
While I can add and delete roles with no problem I cannot find the method to read the current roles of an object based on object ID .
Can anyone help me out ?