This table maintains permissions specifications for application
groups. Each row contains two primary elements: who (id)
and what (agid) and specifies the user's authority
for the application group, the user's document and annotation permissions,
and a query restriction, if any.
Table 1. Application group permissions table (ARSAGPERMS)
| Column Name |
Data Type |
Description |
| id |
INTEGER |
User identifier |
| agid |
INTEGER |
Application group identifier |
| id_perms |
SMALLINT |
User authority for the application group |
| doc_perms |
SMALLINT |
Document permissions |
| ann_perms |
SMALLINT |
Annotation permissions |
| q_restrict |
CLOB(32700) (Db2®), VARCHAR(MAX) (SQL Server), CLOB (Oracle) |
Query restriction; user-defined and validated
SQL string |
Table 2. Indexes for application group
permissions table (ARSAGPERMS)
| Index name |
Columns in index |
Type of index |
| arsagperms_idx |
agid, id |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |