Creating Cassandra user roles with full database access
Give Pega Platform full access to your external database by creating Cassandra user roles with full access permissions.
-
Create a Cassandra user role by running the
create role
CQL command:create role role_name with password = role_password and login = true
create role pega_user with password = passwordxmp and login = true
For more information about thecreate role
CQL command, see the DataStax documentation. -
Give full database access to the user role by running the
grant
CQL command:grant all permission on all keyspaces to rolename
grant all permission on all keyspaces to pegauser
For more information about thegrant
CQL command, see the DataStax documentation.
Configure the connection between Pega Platform and your external Cassandra database. For more information, see Connecting to an external Cassandra database.