Step 1. Configure Permission Management

Use the Schema Manager to manage permissions by rows and columns.

• When using i-META to query data, permissions can be set at the Table's Row and Column levels.
• By default, permissions are granted company-wide, and can be configured by divisions, groups, and users.
• Advanced features such as priority and variable handling can be applied to each permission setting.

1.1 Managing Permissions at the Row Level

1. Double-click the list of tables to set permissions.
   
   
   
   
2. To assign permissions to specific groups or users except the company-wide setting, click the [Authority] tab, right-click on Authority menu, and select [Add permission].
   
   
   
   
3. In the Permission settings window, select a group or user in division to register, and click the [Apply] button. 
   
   
   
   
4. Set the permission level for the selected account, and click the [Save] button. 
   
   

1.2 Setting Data Query Permissions

• Click [Condition] in the table's permission properties to add data query conditions for the user.
• Data is filtered based on the query conditions set for each permission.
• If no query condition is specified, all data will be retrieved.
• Example : [public.sales_customer_en.customer_no] > '50000'
  
  
  
  
  

1.3 Managing Permissions at the Column Level

1. Double-click the column of the table to assign permissions, right-click in the [Authority] tab, and select [Add permission]. 
   
   
   
   
2. In the Permission settings window, select the account to register, then click [Apply] button.
   
   
   
   
3. Set the masking character to replace data during queries based on the group or user.
   
   

1.4 Setting Permission Management Priorities

• When setting permission at the row and column levels, you can specify the priority of permissions.
• Priorities can be set based on importance, and if permission information overlaps, the permission with higher priority is applied.