This table maintains permissions specifications for folders.
Each row contains two primary elements: the user (id)
and the folder (fid) and specifies the user's authority
for the folder, fields, and named queries.
Table 1. Folder permissions table (ARSFOLPERMS)
| Column Name |
Data Type |
Description |
| id |
INTEGER |
User identifier |
| fid |
INTEGER |
Folder identifier |
| perms |
SMALLINT |
User permissions for the folder |
| hits |
INTEGER |
Maximum hits returned from a query |
Table 2. Indexes for folder permissions
table (ARSFOLPERMS)
| Index name |
Columns in index |
Type of index |
| arsfolperms_idx |
fid, id |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |