This documentation site is for previous versions.

Visit our new documentation site for current releases.

Creating Cassandra user roles with full database access

Updated on July 5, 2022

This content applies only to On-premises and Client-managed cloud environments

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:

$ cqlsh -u cassandra -p cassandra -e "CREATE ROLE role_name WITH PASSWORD = 'role_password' AND LOGIN = true;"

For more information about the create role CQL command, see the DataStax documentation.

Give full database access to the user role by running the grant CQL command:
```
$ cqlsh -u cassandra -p cassandra -e "GRANT ALL PERMISSIONS ON ALL KEYSPACES TO role_name;"
```
For example:
```
$ cqlsh -u cassandra -p cassandra -e "GRANT ALL PERMISSIONS ON ALL KEYSPACES TO pegauser;"
```
For more information about the grant CQL command, see the DataStax documentation.

What to do next: Configure the connection between Pega Platform and your external Cassandra database. For more information, see Connecting to an external Cassandra database through the Decision Data Store service.

Previous topic Defining Pega Platform access to an external Cassandra database
Next topic Creating Cassandra user roles with limited database access

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Visit the Support Center

Did you find this content helpful?

Yes

No

Want to help us improve this content?

Suggest an edit

Contact us