Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# pmobjects_security

The `pmobjects_security` table stores the encrypted security settings for every procedure object (except shortcuts) in the Procedure Management library.

## Structure

The `pmobjects_security` table has the following structure:

    TABLE pmobjects_security (
    	object_guid	VARCHAR(36)		NOT NULL,
    	security_id	INTEGER			NOT NULL,
    	attrib_expr	VARCHAR(260)		NOT NULL,
    	security_level	VARCHAR(8)		NOT NULL)

Column | Description
`object_guid` | ID for this procedure object, as defined in the pm_objects table.
`security_id` | Internal identifier for this procedure object.
`attrib_expr` | Encrypted security attribute expression for this procedure object.
`security_level` | Encrypted security level for this procedure object.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_pmobjects_sec` `urity` | `object_guid security_id`

## Triggers

None.

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed
`idx_pmobjects_security_fk` | `object_guid`

## Table Activity

The `pmobjects_security` table contains one row for each procedure object (except shortcuts) in the Procedure Management library.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a procedure object is created.
updated | a procedure object’s security settings are modified.
deleted | a procedure object is deleted.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine