Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

User Defined Roles

      +
      Learn how to create custom roles in Enterprise Analytics to implement granular access control that matches your organization’s specific security requirements.

      Enterprise Analytics allows you to create custom roles tailored to your organization’s specific access control needs. Create user-defined roles to group privileges logically and assign them to multiple users for consistent security management across your database environment.

      This information is stored in the Metadata.Role collection.

      Create Role

      The CREATE ROLE statement creates a new role for use within an Enterprise Analytics instance.

      Create Role Diagram
      create_role ::= 'CREATE' 'ROLE' role

      Role names are global within an Enterprise Analytics instance. They must be unique across databases and scopes or else the create attempt fails.

      Drop Role

      The DROP ROLE statement drops an existing role from an Enterprise Analytics instance.

      Drop Role Diagram
      drop_role ::=

      The role dropped must not be in use, otherwise the drop attempt returns an error.

      Example

      The following example creates a user-defined role named roleName with specific privileges:

      CREATE ROLE roleName;
DROP ROLE roleName