• Glossary
  • Support
  • Downloads
  • DataStax Home
Get Live Help
Expand All
Collapse All

DataStax Enterprise 6.8 Security Guide

    • About DSE Advanced Security
    • Security FAQs
    • Security checklists
    • Securing the environment
      • Securing ports
      • Securing the TMP directory
    • Authentication and authorization
      • Configuring authentication and authorization
        • About DSE Unified Authentication
          • Steps for new deployment
          • Steps for production environments
        • Configuring security keyspaces
        • Setting up Kerberos
          • Kerberos guidelines
          • Enabling JCE Unlimited
            • Removing AES-256
          • Preparing DSE nodes for Kerberos
            • DNS and NTP
            • krb5.conf
            • Principal
            • Keytab
        • Enabling authentication and authorization
          • Defining a Kerberos scheme
          • Defining an LDAP scheme
        • Configuring JMX authentication
        • Configuring cache settings
        • Securing schema information
      • Managing database access
        • About RBAC
        • Setting up logins and users
          • Adding a superuser login
          • Adding database users
          • LDAP users and groups
            • LDAP logins
            • LDAP groups
          • Kerberos principal logins
          • Setting up roles for applications
          • Binding a role to an authentication scheme
        • Assigning permissions
          • Database object permissions
            • Data resources
            • Functions and aggregate resources
            • Search indexes
            • Roles
            • Proxy login and execute
            • Authentication schemes
            • DSE Utilities (MBeans)
            • Analytic applications
            • Remote procedure calls
          • Separation of duties
          • Keyspaces and tables
          • Row Level Access Control (RLAC)
          • Search index permissions
          • DataStax Graph keyspace
          • Spark application permissions
          • DataStax Studio permissions
          • Remote procedure calls
          • DSE client-tool spark
          • JMX MBean permissions
          • Deny (denylist) db object permission
          • Restricting access to data
      • Providing credentials from DSE tools
        • About clients
        • Internal and LDAP authentication
          • Command line
          • File
          • Environment variables
          • Using CQLSH
        • Kerberos
          • JAAS configuration file location
          • Keytab
          • Ticket Cache
          • Spark jobs
          • SSTableLoader
          • Graph and gremlin-console
          • dsetool
          • CQLSH
        • Nodetool
        • JConsole
    • Auditing database activity
      • Enabling database auditing
      • Capturing DSE Search HTTP requests
      • Log formats
      • View events from DSE audit table
    • Transparent data encryption
      • About Transparent Data Encryption
      • Configuring local encryption
        • Setting up local encryption keys
        • Encrypting configuration file properties
        • Encrypting system resources
        • Encrypting tables
        • Rekeying existing data
        • Using tools with TDE-encrypted SSTables
        • Troubleshooting encryption key errors
      • Configuring KMIP encryption
      • Encrypting Search indexes
        • Encrypting new Search indexes
        • Encrypting existing Search indexes
        • Tuning encrypted Search indexes
      • Migrating encrypted tables from earlier versions
      • Bulk loading data between TDE-enabled clusters
    • Configuring SSL
      • Steps for configuring SSL
      • Creating SSL certificates, keystores, and truststores
        • Remote keystore provider
        • Local keystore files
      • Securing node-to-node connections
      • Securing client-to-node connections
        • Configuring JMX on the server side
        • nodetool, nodesync, dsetool, and Advanced Replication
        • JConsole (JMX)
        • SSTableloader
        • Connecting to SSL-enabled nodes using cqlsh
      • Enabling SSL encryption for DSEFS
      • Reference: SSL instruction variables
    • Securing Spark connections
  • DataStax Enterprise 6.8 Security Guide
  • Authentication and authorization
  • Managing database access
  • Assigning permissions
  • Database object permissions
  • Functions and aggregate resources

Functions and Aggregate Resources

Locate the cassandra.yaml file. The location of this file depends on the type of installation:

  • Package installations: /etc/dse/cassandra/cassandra.yaml

  • Tarball installations: <installation_location>/resources/cassandra/conf/cassandra.yaml

The function syntax applies to user-defined functions and aggregates. Although user-defined functions and aggregates are located in a keyspace, function permissions are distinct and must be applied separately.

Access is controlled using modelled hierarchy. Granting and revoking a privilege on a top level object automatically allows the same permission on all ancestors.

Restriction: User defined functions are only available in environments that have enable_user_defined_functions set to true in the cassandra.yaml file.

Locate the cassandra.yaml file. The location of this file depends on the type of installation:

  • Package installations: /etc/dse/cassandra/cassandra.yaml

  • Tarball installations: <installation_location>/resources/cassandra/conf/cassandra.yaml

Functions have the following hierarchy.

cql functions hierarchy

Synopsis

Use the following syntax to control access to functions:

  • ALL FUNCTIONS syntax:

    GRANT <privilege_list>
    ON **ALL FUNCTIONS**
    TO <role_name>;

    where the privileges are ALL PERMISSIONS, ALTER, CREATE, DROP, and EXECUTE

  • ALL FUNCTIONS IN KEYSPACE syntax:

    GRANT <privilege_list>
    ON **ALL FUNCTIONS IN KEYSPACE <keyspace_name>**
    TO <role_name>;

    where the privileges are ALL PERMISSIONS, ALTER, CREATE, DROP, and EXECUTE

  • FUNCTION syntax:

    GRANT <privilege_list>
    ON **FUNCTION <function_name> ( <argument_types> ) **
    TO <role_name>;

    where the function name is fully qualified and the privileges are ALL PERMISSIONS, ALTER, DROP, and EXECUTE

Revoke permission syntax:

REVOKE <permission_list>
ON resource
FROM role_name;

Permission matrix

When a permission is granted to a role, users are able to perform the corresponding operations.

privilege_name resource_name Permissions

ALL PERMISSIONS

ALL FUNCTIONS

All operations (ALTER, CREATE, DROP, and EXECUTE permissions) on all functions in all keyspaces.

ALL PERMISSIONS

ALL FUNCTIONS IN KEYSPACE

All operations (ALTER, CREATE, DROP, and EXECUTE) on all functions in the selected keyspace.

ALL PERMISSIONS

FUNCTION

All operations (ALTER, DROP, and EXECUTE) on the selected function.

ALTER

ALL FUNCTIONS

CREATE OR REPLACE FUNCTION and CREATE OR REPLACE AGGREGATE on existing functions in all keyspaces.

ALTER

ALL FUNCTIONS IN KEYSPACE <keyspace_name>

CREATE OR REPLACE FUNCTION and CREATE OR REPLACE AGGREGATE on existing functions in a specific keyspace.

ALTER

FUNCTION <function_name>

CREATE OR REPLACE FUNCTION and CREATE OR REPLACE AGGREGATE on an existing function.

CREATE

ALL FUNCTIONS

CREATE FUNCTION and CREATE AGGREGATE in all keyspaces.

CREATE

ALL FUNCTIONS IN KEYSPACE <keyspace_name>

CREATE FUNCTION and CREATE AGGREGATE in specified keyspace.

DROP

ALL FUNCTIONS

DROP FUNCTION and DROP AGGREGATE in all keyspaces.

DROP

ALL FUNCTIONS IN KEYSPACE <keyspace_name>

DROP FUNCTION and DROP AGGREGATE in specified keyspace.

DROP

FUNCTION <function_name>

DROP FUNCTION or DROP AGGREGATE specified function.

EXECUTE

ALL FUNCTIONS

Use a function or aggregate in SELECT, INSERT, and UPDATE in all keyspaces. Create an aggregate that contains a function.

EXECUTE

ALL FUNCTIONS IN KEYSPACE <keyspace_name>

Use a function or aggregate in SELECT, INSERT, and UPDATE in a keypsace. Create an aggregate that contains a function in the keyspace.

EXECUTE

FUNCTION <function_name>

SELECT, INSERT and UPDATE using specified function and use of the function in CREATE AGGREGATE.

Data resources Search indexes

General Inquiries: +1 (650) 389-6000 info@datastax.com

© DataStax | Privacy policy | Terms of use

DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Kubernetes is the registered trademark of the Linux Foundation.

landing_page landingpage