Roles : own , app, devpg
-
-
[Cloud IBM PSQL] Role creation with HVAULT (static dba)
script : prepare_dba_static_role.sh
-
[Cloud IBM PSQL] Role creation with HVAULT
Roles creation using hvault :
- dynamic roles
The roles are created with this command :
vault write -ns="$VAULT_NAMESPACE/$ECOSYSTEM" database/postgres/${SERVER}/roles/${ROLE}
db_name=${SERVER}
creation_statements=@${ORA2PG_HOME}/dynamic_role/${TYPE}/create_dyna_role_${TYPE}_${ASSET}.sql
revocation_statements=@${ORA2PG_HOME}/dynamic_role/${TYPE}/drop_dyna_role_${TYPE}_${ASSET}.sql
default_ttl=${ROTATION}
max_ttl=${ROTATION}