Inheritance of object permissions

When a new ObjectServer object is created, permissions are automatically granted to the new object based on the permissions currently granted to its parent.

For example, if SuperAdmin has CREATE_DATABASE permission, and LondonAdmin creates a database, by default SuperAdmin has all object permissions on the database that LondonAdmin created.

If the permissions on a parent object are changed after a child object is created, there is no change to the child object's permissions.

The following table lists the child objects for each ObjectServer parent object.

Table 1. Inheritance of object permissions
Parent object Child objects
System

Database

Trigger group

File

SQL procedure

External procedure

Signal

Restriction filter
Database

Table

View
Table

Index
Trigger group

Trigger