Online Documentation for SQL Manager for DB2

Security Label Components


A Security label component is a database object that represents a criterion you want to use to determine if a user should access a piece of data. It is a part of label-based access control. This object is available only for database server version 9.7 and higher.

 

 

Creating Security Label Components

 

To create a new security label component:

  • select the Database | New Object... main menu item;
  • select Security label component in the Create New Object dialog;
  • edit Security label component properties using the appropriate tabs of Security label component.

Hint: To create a new security label component, you can also right-click the Security label component node of the DB Explorer tree and select the New security label component... context menu item.

 

 

Editing Security Label Components

 

To edit an existing security label component:

  • select the security label component for editing in the DB Explorer tree (type the first letters of the security label component name for quick search);
  • right-click the object and select the Edit Security label component <component_name>... context menu item, or simply double-click the security label component;
  • edit security label component definition using the appropriate tabs of security label component editor.

 

Dropping Security Label Components

 

To drop a security label component:

  • select the security label component to drop in the DB Explorer tree;
  • right-click the object and select the Drop Security label component <component_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new security label component;

Ctrl+O to edit the selected security label component;

Shift+Del to drop the object from the database.