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.