페이지 이력

Step 1. 권한 관리 설정하기

Schema 관리자를 이용해 Row, Column 단위로 권한을 관리합니다.

• i-META를 활용하여 데이터를 조회하는 경우 Table의 Row, Column 단위로 권한 설정이 가능합니다.
• Default로 전사에 권한이 부여되며 설정에 따라 부서, 그룹, 사용자 별로 권한 설정이 가능합니다.
• 각각의 권한 설정에 대하여 우선순위, 변수 처리와 같은 고급 기능을 사용할 수 있습니다.

1.1 Row 단위 권한 관리

...

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.
   
   Image Added
   
   
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].
   
   Image Added
   
   
3. In the Permission settings window, select a group or user in division to register, and click the [Apply] button. 
   
   Image Added
   
   
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'
  
  
  
  
  

조건 명령어는 SQL문이며 Row 데이터를 제한할 필드명은 '스키마.테이블.컬럼'으로 설정합니다.

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]. 
   
   Image Added
   
   
2. In the Permission settings window, select the account to register, then click [Apply] button.
   
   Image Added
   
   
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.