Hello,
We have an audit requirement to produce a report of all users with access to the database task and scheduled database task screens in IFS.
Specifically we need to be able to show who can create/modify records in both these screens.
Can someone provide guidance on the SQL required to achieve the above please?
Thanks
This is not a straightforward SQL method, but more like a workaround I used for a similar instance. We can use the ‘new permission sets’ window, to search users who have access to those mentioned windows
There are actually 3 windows in the navigator for ‘Database Tasks’ & ‘Scheduled Database Tasks’ together. For them I believe permissions are granted under activities ManageTasks, TaskScheduling and TaskScheduling2.
So, populate any permission set in the ‘New permission set’ window -> go to ‘Activities’ tab -> search ManageTasks under ‘Find Activity’ and click Find.
Then click on the ‘ManageTasks’ result, it will direct to the activity name ‘ManageTasks’ with a checkbox.
Click ‘right mouse button’ on it -> ‘Show Grantees’ – this will list down all the permission sets which have access to this activity.
Then Search one of the permission set in the ‘New Permission Set’ window, click the ‘Show Users granted this’ link in top right corner - this will list down users who have access to those windows.
Repeat for every unique permission set you find in those 3 activities to list down all the users who have access to those windows.
Hope this will be helpful.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
