Authorization table?

Former Member — Wed, 18 Jul 2007 11:39:17 GMT

In 2004s,

Does anyone know the table that contains the user ID and their assigned Profitcenter hierarchy node (using 0Profitcenter as Auth relevant)?

We need a quick way to validate the correct assignments by user.

Re: Authorization table?

Former Member — Wed, 18 Jul 2007 12:53:29 GMT

I am not sure exactly what you are looking for but here are a few tables that might help

RSECAUTHTRUSER - list users assigned to authorizations

RSECHIE - links authorizations-characteristic-hierachy name and piece

RSECHIEVIEW - user to authorization to hierachy to infoobject

RSECUSERAUTH - user to authorization

RSECVAL - authorization to characteristic to value (values not in a hierarchy)

RSECVALVIEW - user to authorization to infoobject (characteristic) to value not in hierarchy