USER MANUALS

GET_GLOBAL_SECURITY_POLICIES_TAGS

Description

The stored procedure GET_GLOBAL_SECURITY_POLICIES_TAGS returns information about the tags used by global security policies. To use this stored procedure the user must be administrator of the database.

Syntax

GET_GLOBAL_SECURITY_POLICIES_TAGS (
      input_tag_names : array
    , input_global_security_policy_names : array
)

  • input_tag_names: list of names of the tags where the global security policy belong to (optional).

  • input_global_security_policy_names: list of names of global security policies (optional).

The output schema has the following fields:

  • tag_name: name of the tag.

  • tag_description: description of the tag.

  • tag_user_creator: user that create the tag.

  • tag_last_user_modifier: last user that modified the tag.

  • tag_create_date: creation date of the tag.

  • tag_last_modification_date: last modification date of the tag.

  • global_security_policy_name: name of the global security policy.

  • global_security_policy_description: description of the global security policy.

  • global_security_policy_user_creator: user that create the global security policy.

  • global_security_policy_last_user_modifier: last user that modified the global security policy.

  • global_security_policy_create_date: creation date of the global security policy.

  • global_security_policy_last_modification_date: last modification date of the global security policy.

Privileges Required

  • Administrator user: can view all tags and global security policies.

  • Local administrator user: can view tags and global security policies related to his databases.

Examples

Example 1

SELECT * from GET_GLOBAL_SECURITY_POLICIES_TAGS()

Obtains all global security policies with tags used, in this case, of all databases which the user is administrator.

Example 2

SELECT * from GET_GLOBAL_SECURITY_POLICIES_TAGS()
   WHERE INPUT_TAG_NAMES = {ROW('mask_column_1'), ROW('mask_column_2')}

Obtains all global security policies that use the tag ‘mask_column_1’ and ‘mask_column_2’.

Example 3

SELECT * from GET_GLOBAL_SECURITY_POLICIES_TAGS()
   WHERE INPUT_TAG_NAMES = {ROW('mask_column')} AND INPUT_GLOBAL_SECURITY_POLICY_NAMES = {ROW('global_security_policy_1')}

Obtains ‘global_security_policy_1’ global security policy relative to the tag ‘mask_column’.

Add feedback