Online Documentation for SQL Manager for DB2

Security Policies


Security policy is used to define criteria that determine who has write access and who has read access to individual rows and individual columns of tables. It is also a part of label-based access control. This object is available only for database server version 9.7 and higher.

 

 

Creating Security Policies

 

To create a new security policy:

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

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

 

 

Editing Security Policies

 

To edit an existing security policy:

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

 

Dropping Security Policies

 

To drop a security policy:

  • select the security policy to drop in the DB Explorer tree;
  • right-click the object and select the Drop Security policy <policy_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 policy;

Ctrl+O to edit the selected security policy;

Shift+Del to drop the object from the database.