aioc.sapm_account
Table where the SAPM accounts are stored (secrets both static and dynamic).
Column | Data Type | Description |
|---|---|---|
Db_id | Bigint | Primary Key |
Username | Varchar | UserName |
Password | Varchar | Password |
Previous Password | Varchar | Previous Password |
Change_Period | Bigint | Change Period |
Last_Change_Time | Date | Last Change Date |
Next_Change_Time | Date | Next Change Date |
Password_seen_status | Varchar | Password Seen Status (UNSEEN/SEEN) |
Validation_status | Varchar | Password validation between the account |
First_part_seen_username | Varchar | For Split password feature |
Last_attempt_status | Char | Last attempt status |
Device_id | Bigint | Foreign key to t_device table |
Config_id | Bigint | Foreign key to sapm_config table |
Master_account_id | Bigint | Â |
Second_part_seen_username | Varchar | For Split password feature |
Parent_sapm_group_id | Bigint | Foreign Key to SAPM Group table for Tree like Structure |
Secret_name | Varchar | Secret name |
Private | Varchar | Private Yes flag |
User_Create | Varchar | Created User |
Secret_type | Varchar | STATIC or DYNAMIC |