2007 Jul 18 12:39 PM
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.
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.
2007 Jul 18 1:53 PM
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
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |