1. Manage Object Groups

2. Add an Object Group

To add an object group use API_SCURTY.ADD_OBJECT_GROUP. Specify if the objects in this group will be available read/write or read/only.

Example: add object group ‘TEST_OG’

EXECUTE SCRIPT API_SCURTY.ADD_OBJECT_GROUP (
     'TEST_OG'         -- p_object_group
     ,'Description 1'  -- p_description
     ,null             -- p_read_write
);

After adding an object group using the script above you will find a new entry in the table REP_OBJECT_GROUPS.

OBJECT_GROUP	OG_ID	DESCRIPTION	READ_WRITE
TEST_OG	152	Description 1	true

2.1. Change an Object Group

To change parameters use API_SCURTY.CHANGE_OBJECT_GROUP. Providing NULL leaves the parameters as is, while a blank (’ ‘) restores the default value.

Example: change description and switch to read/write

EXECUTE SCRIPT API_SCURTY.CHANGE_OBJECT_GROUP (
     'TEST_OG'           -- p_object_group
     ,'Description 530'  -- p_description
     ,true               -- p_read_write
);

These changes can be found in the table REP_OBJECT_GROUPS.

OBJECT_GROUP	OG_ID	DESCRIPTION	READ_WRITE
TEST_OG	152	Description	true

2.2. Remove an Object Group

To remove an object group use API_SCURTY.REMOVE_OBJECT_GROUP.

Important

You cannot remove an object group if dependent configurations exist.

Example

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

No entry for the Object Group name ‘TEST_OG’ should be found in REP_OBJECT_GROUPS after issuing this command.