Allow NTC advisors to see all overrides entered in SFASRPO, but can only add/delete/update override records with the ‘PRE-REQ’ Permit Type.
Identify or define a new domain - GTVFDMN
Filter GTVFDMN to determine if your domain exists. Domains should be named based on the affected table and should follow the following naming convention:
SB_SFRSRPO_VBS
Note the existing domain. To create a new domain:
Click Insert. Using the naming convention, define a new name and give it a description. Save.
Connect the domain to the driver table - GORFDMN
If you created a new domain, connect it to its driver table in GORFDMN.
Click Insert. Select or enter the domain. Enter or select the driver table. Select or enter VBS. Save.
Click Insert. Select/enter the domain and table. Check the Active Indicator box. Save.
If you had to create a new domain in the first step OR you created a rule container for an existing domain with a new associated table: have a DBA run gfvbsaddpol.sql to create Oracle policies for all tables defined for the domain before moving to the next step.
If you used an existing domain + table combination, move to the new step after you’ve created the container.
Determine if a group exists to which you are adding this rule. If not, create a new group by clicking Insert. Enter the Code and Description. Save.
Groups should be named oriented with their function.
Select an existing business profile or create a new one by clicking Insert. Enter the code and Description. Save.
Business profiles are groups of individuals; these individuals are being grouped based on their need to do the task the rules allow them to do.
Enter the appropriate SQL code in the Predicate field. Click the Validate SQL button.
If you don’t know the affected field in the table, click the Column button. Selecting the Column Name will populate it in the Predicate field.
In the Access to Predicate tab, select the business profile, or group of users, the rule applies to. Check the functions you DO NOT want them to do. Save.
Select/enter the Business Profile. Go.
Enter the User IDs for all users should should be in this business profile. Save.
Add Comment