Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Sv translation
languagesk

Here is an example of a security level definition.

Let's assume:

  • today's date is 11.11.2020
  • User info is set to 11


We will be using this query:

Code Block
languagesql
select MDS74.L_RESTRICTION from $mainDataset(78) PT JOIN $dataset(74) MDS74 ON (PT.L_EXTENDED=MDS74.L_ADDINFO) where (PT.L_MAIN = '$user(info)' AND PT.L_START<= '$date(now)')

This query will be used as an example of how to use JOIN or variables.


We will be applying our restriction to column L_PARTITION



From the last table where we applied our security level, the logged user will get only rows where Partition value is 1 (orange colour)


Sv translation
languageja

これはセキュリティレベルの定義の例です。

以下仮定します:

  • 今日が2020/11/11とする。
  • ユーザー情報を11に設定します。


以下のクエリを使用します

Here is an example of a security level definition.

Let's assume:

  • today's date is 11.11.2020
  • User info is set to 11

We will be using this query:

Code Block
languagesql
select MDS74.L_RESTRICTION from $mainDataset(78) PT JOIN $dataset(74) MDS74 ON (PT.L_EXTENDED=MDS74.L_ADDINFO) where (PT.L_MAIN = '$user(info)' AND PT.L_START<= '$date(now)')

This query will be used as an example of how to use JOIN or variables.

We will be applying our restriction to column L_PARTITION

Image Removed

このクエリは、JOINまたは変数の使用方法の例として使用されます。


L_PARTITION列に制限を適用します


Image Added


セキュリティレベルを適用した最後のテーブルから、ログに記録されたユーザーは、パーティション値が1 (オレンジ) の行のみを取得します。From the last table where we applied our security level, the logged user will get only rows where Partition value is 1 (orange colour)

Sv translation
languagede

Here is an example of a security level definition.

Let's assume:

  • today's date is 11.11.2020
  • User info is set to 11


We will be using this query:

Code Block
languagesql
select MDS74.L_RESTRICTION from $mainDataset(78) PT JOIN $dataset(74) MDS74 ON (PT.L_EXTENDED=MDS74.L_ADDINFO) where (PT.L_MAIN = '$user(info)' AND PT.L_START<= '$date(now)')

This query will be used as an example of how to use JOIN or variables.


We will be applying our restriction to column L_PARTITION



From the last table where we applied our security level, the logged user will get only rows where Partition value is 1 (orange colour)

...