topic Re: Active and Inactive Objects in Roles in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/active-and-inactive-objects-in-roles/m-p/6350598#M1398817 <HTML><HEAD></HEAD><BODY><P>Have a look at the field "DELETED" in AGR_1251. The inactive objects have an "X" there.</P></BODY></HTML> Mon, 14 Dec 2009 14:09:52 GMT jurjen_heeck 2009-12-14T14:09:52Z Active and Inactive Objects in Roles https://community.sap.com/t5/application-development-and-automation-discussions/active-and-inactive-objects-in-roles/m-p/6350597#M1398816 <HTML><HEAD></HEAD><BODY><P>Hello Security Gurus,</P><P></P><P>I am trying to find a table that lists whether an authorization is active or inactive in a role. Does such a table exist? I found table AGR_1251 that lists roles and all the objects in the role, but I would like to search for only "active" authorizations. For example, I enter the following criteria:</P><P>Role: All roles that fit our naming convention</P><P>Object: S_PROGRAM</P><P>Field name: P_GROUP</P><P>Value: * (single value)</P><P></P><P>The results contain both active and inactive Authorizations for the S_PROGRAM object in the Roles. I would like to filter out the inactive authorizations. Is this possible other than using transaction SUIM?</P><P></P><P>Thank you,</P><P>Janice Derting</P></BODY></HTML> Mon, 14 Dec 2009 14:02:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/active-and-inactive-objects-in-roles/m-p/6350597#M1398816 Former Member 2009-12-14T14:02:44Z Re: Active and Inactive Objects in Roles https://community.sap.com/t5/application-development-and-automation-discussions/active-and-inactive-objects-in-roles/m-p/6350598#M1398817 <HTML><HEAD></HEAD><BODY><P>Have a look at the field "DELETED" in AGR_1251. The inactive objects have an "X" there.</P></BODY></HTML> Mon, 14 Dec 2009 14:09:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/active-and-inactive-objects-in-roles/m-p/6350598#M1398817 jurjen_heeck 2009-12-14T14:09:52Z Re: Active and Inactive Objects in Roles https://community.sap.com/t5/application-development-and-automation-discussions/active-and-inactive-objects-in-roles/m-p/6350599#M1398818 <HTML><HEAD></HEAD><BODY><P>That's exactly what I need! I was using Field Labels and not Field Name and did not notice the Deleted field. Thank you!!</P></BODY></HTML> Mon, 14 Dec 2009 18:20:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/active-and-inactive-objects-in-roles/m-p/6350599#M1398818 Former Member 2009-12-14T18:20:56Z