Creating Cassandra user roles with limited database access
This content applies only to On-premises and Client-managed cloud environments
Define and control Pega Platform access to your external database by creating Cassandra user roles with access to a defined set of keyspaces.
Create keyspaces that are necessary to store decision
management data, and then create user roles with access to the keyspaces.
- Create the following keyspaces by running the
create keyspace
CQL command:adm
adm_commitlog
aggregation
data
states
vbd
Adjust thecreate keyspace
CQL command to your Cassandra cluster settings. For more information about thecreate keyspace
CQL command, see the DataStax documentation. - Create a Cassandra user role by running the
create role
CQL command:create role rolename with password = rolepassword and login = true
For more information about thecreate role
CQL command, see the DataStax documentation. - For each keyspace that you create in step 1, grant the following permissions to the user by running the
grant
CQL command:create
alter
drop
select
modify
For more information about thegrant
CQL command, see the DataStax documentation.
Previous topic Creating Cassandra user roles with full database access Next topic Configuring a Cassandra cluster for internal encryption