Finding all roles which have inactive obj..?

[Former Member]

Hi,

Is there any way to find the roles which have inactive objects.At table level we can find the objects which are inactive or deleted, but i am unable to find the roles which have inactive objects.

Regards

Rakesh

[Former Member]

You can find this in table AGR_1251 - field which indicates "deleted" is field called DELETED.

[Former Member]

Hi,

Table AGR_1251 shows only roles from which objects which have been deleted, is there any way to find the objects which are inactivated only.

Thanks

Rakesh

[Former Member]

In this table, deleted does mean inactive. Test it out this one role. Inactivate an authorization object and then look for it in this table.

[Former Member]

Yepp.. you are right.

I inactivated an obj and checked it. its working.

Thanks

[Former Member]

This means that the objects which are deleted and inactivated are shown in the list.

Thanks

[Former Member]

Yes, if you run any reports or queries from this table make sure that this field is included with not equal value to ensure that only active values are included. Note though that SUIM reports already take this into account so you don't need to specify if you run them.