Single or composite role, which table to check ?

[Former Member]

Hello,

I'm currently trying to find out in which AGR_* table is stored the flag that indicates whether a role is a composite or a single one.

I try AGR_DEFINE but it seems that there is no flag to determine whether the role is single or composite. I can't look in AGR_AGRS because i'm trying to determine composite role without any single role associated and therefore there is no entry in AGR_AGRS.

Do you have any idea ?

Thank you very much for your help !

Jerome.

[Former Member]

Check AGR_FLAGS - the field is "attributes" and the value is COLL_AGR - is there is a "X" in the flag field for the role then it is a composite role.

[Former Member]

Hi,

The tables which will help you as follows.

AGR_AGRS- provides list of Composite roles with all single roles which are there in these composite roles.

where as

AGR_DEFINE - provides the derived role and its parent role.

Regards

Puneet

[dhorions]

You can use the VIEW : V_AGR_COLL

If you go to se11 and look at the join conditions for this view you can see that in orde to have a composite rol, you should look at agr_flags for these conditions

AGR_FLAGS	FLAG_TYPE	EQ	'COLL_AGR'	
AND
AGR_FLAGS	FLAG_VALUE	EQ	'X'	

<edit>

i'm sorry, JC already said this, I missed that

</edit>

Message was edited by:

Dries Horions