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.

1. 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 the create role CQL command, see the DataStax documentation.

2. 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 the grant CQL command, see the DataStax documentation.