Dynamo Application Framework uses the following tables to store security information:
das_gsa_subscriber
This table contains information used by the SQL Repository caching feature when you use cachemode="distributed" on one or more item descriptors. This table is automatically populated by the SQL Repository at application startup and used by each server to determine which other servers need to receive cache invalidation events when items are modified.
Column | Data Type | Constraint |
|---|---|---|
| INTEGER | NOT NULL |
The unique identifier associated with the server. | ||
| VARCHAR(15) | NOT NULL |
The IP address of the | ||
| INTEGER | NOT NULL |
The port number of the | ||
| VARCHAR(256) | NOT NULL |
The name of the |
das_id_generator
The SQLIdGenerator service uses this table to generate IDs.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(60) | NOT NULL |
A string that uniquely identifies an | ||
| NUMERIC(19) | NOT NULL |
The first ID in the space to reserve. | ||
| INTEGER | NOT NULL |
How many IDs to reserve at a time. | ||
| VARCHAR(10) | NULL |
A string to prepend to the beginning of all string IDs generated from this | ||
| VARCHAR(10) | NULL |
A string to append to the end of all string IDs generated from this |
das_secure_id_gen
The ObfuscatedSQLIdGenerator service uses this table to generate Ids that are difficult to guess.
Column | Date Type | Constraint |
|---|---|---|
| VARCHAR(60) | NOT NULL |
A string that uniquely identifies an | ||
seed | NUMERIC(19) | NOT NULL |
The first ID in the space to reserve. | ||
| INTEGER | NOT NULL |
How many IDs to reserve at a time. | ||
| INTEGER | NULL |
The number of IDs to reserve per batch. | ||
| VARCHAR(10) | NULL |
A string to prepend to the beginning of all string IDs generated from this | ||
| VARCHAR(10) | NULL |
A string to append to the end of all string IDs generated from this |
das_account
This table contains a list of accounts, groups, and privileges to be used by Dynamo and the ATG Control Center for administration purposes.
Column | Data Type | Constraint |
|---|---|---|
| WVARCHAR(254) | NOT NULL |
The name of the account a user types to log in. | ||
| INTEGER | NOT NULL |
The type of account: (1) a login account that a user can use to log in, (2) a group account used for organization, or (3) a privilege account to control access to Dynamo and/or ATG Control Center features. | ||
| WVARCHAR(254) | NULL |
For a login (type 1) account, the first name of the user. | ||
| WVARCHAR(254) | NULL |
For a login (type 1) account, the last name of the user. | ||
| VARCHAR(254) | NULL |
For a login (type 1) account, the encrypted password that verifies the user’s identity. | ||
| WVARCHAR(254) | NULL |
For a group (type 2) account, this is the name of the account that displays in the ATG Control Center. |
das_group_assoc
This table associates accounts with the groups and privileges of which they are members.
Column | Data Type | Constraint |
|---|---|---|
| WVARCHAR(254) | NOT NULL |
The name of an account that has a group or privilege association. | ||
| INTEGER | NOT NULL |
An index number used to define the order of groups. This is required by the SQL Repository for array properties. | ||
| WVARCHAR(254) | NOT NULL |
The name of the group of which the account is a member. |
das_sds
This table contains information about data source switching. Each row in the table corresponds to the state of a single switching data source service.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(50) | NOT NULL |
The name of the switching data source. | ||
| VARCHAR(50) | NULL |
The name of the data source that the switching data source is currently using. | ||
| VARCHAR(80) | NULL |
A pseudo-ID for the Dynamo server where the switching data source is running. This can be, but does not have to be, a unique ID. | ||
| TIMESTAMP | NULL |
The time of the last switch operation or the time the switching data source was first started. |
