on 2007 Feb 06 3:18 AM
Hi gurus.
I have a query and I need to know to which roles have it been assigned to?
Appreciate if you could show me how.
Thanks.
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All,
To identify which role is assigned to specific query you can use below SQL statement (use fields OBJ_FROM, OBJ_TO).
SELECT DISTINCT
ROLES.AGR_NAME AS COMPOSITE_ROLE,
ROLES.CHILD_AGR AS SINGLE_ROLE,
UNAME AS USER,
ROLE_CONTENT.REPORT,
ROLE_CONTENT_QUERY.FIELD AS OBJ_TYPE,
ROLE_CONTENT_QUERY.LOW AS OBJ_FROM,
ROLE_CONTENT_QUERY.HIGH AS OBJ_TO
FROM AGR_AGRS AS ROLES
LEFT JOIN AGR_USERS AS USERS ON USERS.AGR_NAME = ROLES.AGR_NAME
LEFT JOIN AGR_HIER AS ROLE_CONTENT ON ROLE_CONTENT.AGR_NAME = ROLES.CHILD_AGR
LEFT JOIN AGR_1251 AS ROLE_CONTENT_QUERY ON ROLE_CONTENT_QUERY.AGR_NAME = ROLES.CHILD_AGR;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
56 | |
10 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.