on 10-08-2015 6:20 AM
Hi Dear Experts,
We have many jobs in SAP FIM 10, and these jobs has many users (executed).
Now we need to make a matrix of users with available jobs, example:
May be some 'select' from database or something else?
Thanks...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Daulet
Something like this
select distinct(USER_NAME), job_name
from FIM_JOB_RUN_STATUS
Marc
Hi Marc,
thanks for answer,
but you 'select' is not working if example user does not never run job, but have permissions to run this job.
I think that table FIM_JOB_RUN_STATUS is showing only launched jobs.
Hello Daulet,
The users who can run the jobs can be retrieved by this:
SELECT [job_name]
,[user_name]
FROM [FIM_JOB_TO_USER]
WHERE [job_name] = 'ABCD'
Note: it will list all the users you have added to the job (see below) + all FIM administrator users (who implicitly have this right)
Thank you very much Marc!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.