1. Manage Object Groups

An object group combines database objects, which are assigned by search rules. Access rights are granted per object group.

1.1. Add an Object Group

To add an object group, use API_SCURTY.ADD_OBJECT_GROUP. p_read_write defines whether write access can be granted for the objects of this group (default false, i.e. read-only).

Example: Add the Object Group ‘TEST_OG’

1EXECUTE SCRIPT API_SCURTY.ADD_OBJECT_GROUP(
2    'TEST_OG'          -- p_object_group
3   ,'Description 1'    -- p_description
4   ,null               -- p_read_write (default false)
5);

The new object group is stored in SCURTY.REP_OBJECT_GROUPS:

OBJECT_GROUP

OG_ID

DESCRIPTION

READ_WRITE

TEST_OG

152

Description 1

false

Next, assign the objects with search rules.

1.2. Change an Object Group

To change an object group, use API_SCURTY.CHANGE_OBJECT_GROUP. NULL leaves a parameter unchanged, while a blank (’ ‘) restores its default value.

Example: Change the Description and Allow Write Access

1EXECUTE SCRIPT API_SCURTY.CHANGE_OBJECT_GROUP(
2    'TEST_OG'            -- p_object_group
3   ,'Description 530'    -- p_description
4   ,true                 -- p_read_write
5);

The entry in SCURTY.REP_OBJECT_GROUPS has changed:

OBJECT_GROUP

OG_ID

DESCRIPTION

READ_WRITE

TEST_OG

152

Description 530

true

1.3. Remove an Object Group

To remove an object group, use API_SCURTY.REMOVE_OBJECT_GROUP.

Warning

Removing an object group also deletes, without further confirmation, all its search rules and all access rights of users to this object group, including their tenant access.

Example: Remove the Object Group ‘TEST_OG’

1EXECUTE SCRIPT API_SCURTY.REMOVE_OBJECT_GROUP(
2    'TEST_OG'    -- p_object_group
3);

The object group ‘TEST_OG’ is removed from SCURTY.REP_OBJECT_GROUPS.