Privilege Hierarchy

The privilege hierarchy mirrors the server object hierarchy. 

  1. Server
    1. Database
      1. Table
        1. Field
        2. Record
        3. Index
      2. CodePackage
      3. Procedure
      4. Sequence
      5. Synonym
      6. Trigger
      7. View
    2. Backup
    3. Connection
    4. ConnectorService
    5. MqBroker
      1. MqSession
      2. MqTopic
      3. ExternalBrokerConnection
    6. Replication

 

The security privilege hierarchy is separate from the server hierarchy.

  1. Server
    1. Account
    2. Role

 

Privilege Name Description
alterAnyAccount Controls a role's ability to update all accounts. This privilege must be explicitly permitted or denied.
alterAnyCodePackageInAnyDatabase Controls a role's ability to update all code packages. This privilege must be explicitly permitted or denied.
alterAnyCodePackageInOneDatabase Controls a role's ability to update all code packages in a specified database. This privilege must be explicitly permitted or denied for each database.
alterAnyExternalBrokerConnection Controls a role's ability to update all external broker connections. This privilege must be explicitly permitted or denied.
alterAnyMqSession Controls a role's ability to update all MQTT or MQ sessions. This privilege must be explicitly permitted or denied.
alterAnyMqTopic Controls a role's ability to update all MQTT Topics. This privilege must be explicitly permitted or denied.
alterAnyProcedureInAnyDatabase Controls a role's ability to update all procedures. This privilege must be explicitly permitted or denied.
alterAnyProcedureInOneDatabase Controls a role's ability to update all procedures in a specified database. This privilege must be explicitly permitted or denied for each database.
alterAnyRole Controls a role's ability to update all roles. This privilege must be explicitly permitted or denied.
alterAnySequenceInAnyDatabase Controls a role's ability to update all sequences. This privilege must be explicitly permitted or denied.
alterAnySequenceInOneDatabase Controls a role's ability to update all sequences in a specified database. This privilege must be explicitly permitted or denied for each database.
alterAnyTableInAnyDatabase Controls a role's ability to update all tables. This privilege must be explicitly permitted or denied.
alterAnyTableInOneDatabase Controls a role's ability to update all tables in a specified database. This privilege must be explicitly permitted or denied for each database.
alterAnyViewInAnyDatabase Controls a role's ability to update all SQL views. This privilege must be explicitly permitted or denied.
alterAnyViewInOneDatabase Controls a role's ability to update all SQL views in a specified database. This privilege must be explicitly permitted or denied for each database.
alterOneAccount Controls a role's ability to update a specific account. This privilege must be explicitly permitted or denied for each account.
alterOneCodePackage Controls a role's ability to update a specific code package. This privilege must be explicitly permitted or denied for each code package.
alterOneExternalBrokerConnection Controls a role's ability to update a specific external broker connection. This privilege must be explicitly permitted or denied for each connection.
alterOneMqSession Controls a role's ability to update a specific MQTT or MQ session. This privilege must be explicitly permitted or denied for each MQTT or MQ session.
alterOneMqTopic Controls a role's ability to update a specific MQTT topic. This privilege must be explicitly permitted or denied for each MQTT topic.
alterOneProcedure Controls a role's ability to update a specific procedure. This privilege must be explicitly permitted or denied for each procedure.
alterOneRole Controls a role's ability to update a specific role. This privilege must be explicitly permitted or denied for each role.
alterOneSequence Controls a role's ability to update a specific sequence. This privilege must be explicitly permitted or denied for each sequence.
alterOneTable Controls a role's ability to update a specific table. This privilege must be explicitly permitted or denied for each table.
alterOneView Controls a role's ability to update a specific SQL view. This privilege must be explicitly permitted or denied for each view.
attachAnyTableInAnyDatabase Controls a role's ability to attach tables to any database. This privilege must be explicitly permitted or denied.
attachAnyTableInOneDatabase Controls a role's ability to attach tables to a specific database. This privilege must be explicitly permitted or denied for each database.
cloneAnyCodePackageInAnyDatabase Controls a role's ability to clone any code package. This privilege must be explicitly permitted or denied.
cloneAnyCodePackageInOneDatabase Controls a role's ability to clone any code package in a specific database. This privilege must be explicitly permitted or denied for each database.
cloneOneCodePackage Controls a role's ability to clone a specific code package. This privilege must be explicitly permitted or denied for each code package.
connectToAnyMqSession Controls a role's ability to connect to any MQTT and MQ session. This privilege must be explicitly permitted or denied.
connectToAnyServer Controls a role's ability to connect to the server through any of its protocols, including the JSON API, MQTT, SQL, and ISAM. This privilege must be explicitly permitted or denied. Denying this privilege on an account's built-in role is equivalent to disabling the account. This privilege is not sufficient to connect to the MQTT broker: you also need a 'connectToAnyMqSession', 'connectToOneMqSession', or 'createAnyMqSession' privilege.
connectToOneMqSession Controls a role's ability to connect to a specific MQTT or MQ session. This privilege must be explicitly permitted or denied for each MQTT client id.
controlAnyReplicationInAnyDatabase Controls a role's ability to do replication operations for any database, such as starting and stopping replication.
controlAnyBackupInAnyDatabase Controls a role's ability to do backup and restore operations for any database.
controlAnyFileblockInAnyTableInAnyDatabase Controls a role's ability to do file block operations on all tables in all databases. File block is a low-level ISAM feature that blocks access to a file. It is slightly more powerful than having exclusive access to a file.
controlAnyTriggerInAnyTableInAnyDatabase Controls a role's ability to enable or disable triggers on all tables in all databases.
controlAnyTriggerInAnyTableInOneDatabase Controls a role's ability to enable or disable triggers on all tables in a specified database.
createAnyAccount Controls a role's ability to create a new account. This privilege must be explicitly permitted or denied.
createAnyCodePackageInAnyDatabase Controls a role's ability to create a new code package in any database. This privilege must be explicitly permitted or denied.
createAnyCodePackageInOneDatabase Controls a role's ability to create a new code package in one specified database. This privilege must be explicitly permitted or denied for each database.
createAnyDatabase Controls a role's ability to create a new database. This privilege must be explicitly permitted or denied.
createAnyExternalBrokerConnection Controls a role's ability to create a new external broker connection. This privilege must be explicitly permitted or denied.
createAnyMqSession Controls a role's ability to create a new MQTT or MQ session. This privilege must be explicitly permitted or denied.
createAnyMqTopic Controls a role's ability to create a new MQTT topic. This privilege must be explicitly permitted or denied.
createAnyProcedureInAnyDatabase Controls a role's ability to create a new procedure in any database. This privilege must be explicitly permitted or denied.
createAnyProcedureInOneDatabase Controls a role's ability to create a new procedure in a specified database. This privilege must be explicitly permitted or denied for each database.
createAnyRole Controls a role's ability to create a new role. This privilege must be explicitly permitted or denied.
createAnySequenceInAnyDatabase Controls a role's ability to create a new sequence in any database. This privilege must be explicitly permitted or denied.
createAnySequenceInOneDatabase Controls a role's ability to create a new sequence in a specific database. This privilege must be explicitly permitted or denied for each database.
createAnySynonymInAnyDatabase Controls a role's ability to create a new synonym in any database. This privilege must be explicitly permitted or denied.
createAnySynonymInOneDatabase Controls a role's ability to create a new synonym in a specific database. This privilege must be explicitly permitted or denied for each database.
createAnyTableInAnyDatabase Controls a role's ability to create a new table in any database. This privilege must be explicitly permitted or denied.
createAnyTableInOneDatabase Controls a role's ability to create a new table in a specific database. This privilege must be explicitly permitted or denied for each database.
createAnyViewInAnyDatabase Controls a role's ability to create a new SQL view in any database. This privilege must be explicitly permitted or denied.
createAnyViewInOneDatabase Controls a role's ability to create a new SQL view in a specific database. This privilege must be explicitly permitted or denied for each database.
deleteAnyExternalBrokerConnection Controls a role's ability to delete any external broker connection. This privilege must be explicitly permitted or denied.
deleteAnyMqSession Controls a role's ability to delete any MQTT or MQ session. This privilege must be explicitly permitted or denied.
deleteAnyMqTopic Controls a role's ability to delete any MQTT topic. This privilege must be explicitly permitted or denied.
deleteAnyRecordInAnyTableInAnyDatabase Controls a role's ability to delete any record anywhere. This privilege must be explicitly permitted or denied.
deleteAnyRecordInAnyTableInOneDatabase Controls a role's ability to delete all records in all tables in a specified database. This privilege must be explicitly permitted or denied for each database.
deleteAnyRecordInOneTable Controls a role's ability to delete all records in a specified table. This privilege must be explicitly permitted or denied for each table.
deleteOneExternalBrokerConnection Controls a role's ability to delete a specific external broker connection. This privilege must be explicitly permitted or denied for each external broker connection. It is particularly useful to prevent a role from deleting a specific external broker connection.
deleteOneMqSession Controls a role's ability to delete a specific MQTT or MQ session. This privilege must be explicitly permitted or denied for each MQTT or MQ session. It is particularly useful to prevent a role from deleting a specific MQTT or MQ session.
deleteOneMqTopic Controls a role's ability to delete a specific MQTT topic. This privilege must be explicitly permitted or denied for each MQTT topic. It is particularly useful to prevent a role from deleting a specific MQTT topic.
describeAnyAccount Controls a role's ability to view all accounts and access their details. This privilege must be explicitly permitted or denied.
describeAnyCodePackageInAnyDatabase Controls a role's ability to view all code packages and access their details. This privilege must be explicitly permitted or denied.
describeAnyCodePackageInOneDatabase Controls a role's ability to view all code packages in a specified database. This privilege must be explicitly permitted or denied for each database.
describeAnyConnectorService Controls a role's ability to view all connector services and access their details. Connector services include "modbus", "opcua", and "siemensS7". This privilege must be explicitly permitted or denied.
describeAnyDatabase Controls a role's ability to view all databases, including the SQL dictionary tables, and access their details. This privilege must be explicitly permitted or denied.
describeAnyExternalBrokerConnection Controls a role's ability to view all external broker connections and access their details. This privilege must be explicitly permitted or denied.
describeAnyMqBroker Controls a role's ability to view all MQTT brokers and access their details. This privilege must be explicitly permitted or denied.
describeAnyMqSession Controls a role's ability to view all MQTT or MQ sessions and access their details. This privilege must be explicitly permitted or denied.
describeAnyMqTopic Controls a role's ability to view all MQTT topics and access their details. This privilege must be explicitly permitted or denied.
describeAnyProcedureInAnyDatabase Controls a role's ability to view all SQL stored procedures and access their details. This privilege must be explicitly permitted or denied.
describeAnyProcedureInOneDatabase Controls a role's ability to view all SQL stored procedures in a specified database. This privilege must be explicitly permitted or denied for each database.
describeAnyRole Controls a role's ability to view all roles and access their details. This privilege must be explicitly permitted or denied.
describeAnySequenceInAnyDatabase Controls a role's ability to view all sequences and access their details. This privilege must be explicitly permitted or denied.
describeAnySequenceInOneDatabase Controls a role's ability to view all sequences in a specified database. This privilege must be explicitly permitted or denied for each database.
describeAnyServer Controls a role's ability to view the server's information including the SQL dictionary tables. This privilege must be explicitly permitted or denied.
describeAnySynonymInAnyDatabase Controls a role's ability to view all synonyms and access their details. This privilege must be explicitly permitted or denied.
describeAnySynonymInOneDatabase Controls a role's ability to view all synonyms in a specified database. This privilege must be explicitly permitted or denied for each database.
describeAnyTableInAnyDatabase Controls a role's ability to view all tables and access their details. This privilege must be explicitly permitted or denied.
describeAnyTableInOneDatabase Controls a role's ability to view all tables in a specified database. This privilege must be explicitly permitted or denied for each database.
describeAnyViewInAnyDatabase Controls a role's ability to view all SQL views and access their details. This privilege must be explicitly permitted or denied.
describeAnyViewInOneDatabase Controls a role's ability to view all SQL views in a specified database. This privilege must be explicitly permitted or denied for each database.
describeOneAccount Controls a role's ability to view a specific account and access its details. This privilege must be explicitly permitted or denied for each account.
describeOneCodePackage Controls a role's ability to view a specific code package and access its details. This privilege must be explicitly permitted or denied for each code package.
describeOneConnectorService Controls a role's ability to view a specific connector service and access its details, such as "modbus", "opcua", or "siemensS7". This privilege must be explicitly permitted or denied.
describeOneDatabase Controls a role's ability to view a specific database, including its SQL dictionary tables, and access its details. This privilege must be explicitly permitted or denied for each database.
describeOneExternalBrokerConnection Controls a role's ability to view a specific external broker connection and access its details. This privilege must be explicitly permitted or denied for each external broker connection.
describeOneMqSession Controls a role's ability to view a specific MQTT or MQ session and access its details. This privilege must be explicitly permitted or denied for each MQTT or MQ session.
describeOneMqTopic Controls a role's ability to view a specific MQTT topic and access its details. This privilege must be explicitly permitted or denied for each MQTT topic.
describeOneProcedure Controls a role's ability to view a specific SQL stored procedure and access its details. This privilege must be explicitly permitted or denied for each SQL stored procedure.
describeOneRole Controls a role's ability to view a specific role and access its details. This privilege must be explicitly permitted or denied for each role.
describeOneSequence Controls a role's ability to view a specific sequence and access its details. This privilege must be explicitly permitted or denied for each sequence.
describeOneSynonym Controls a role's ability to view a specific synonym and access its details. This privilege must be explicitly permitted or denied for each synonym.
describeOneTable Controls a role's ability to view a specific table and access its details. This privilege must be explicitly permitted or denied for each table.
describeOneView Controls a role's ability to view a specific SQL view and access its details. This privilege must be explicitly permitted or denied for each SQL view.
describeTheSecurityOfAnyCodePackageInAnyDatabase Controls a role's ability to view the security of any code package. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnyCodePackageInOneDatabase Controls a role's ability to view the security of any code package in a specific database. This privilege must be explicitly permitted or denied for each database.
describeTheSecurityOfAnyDatabase Controls a role's ability to view the security of any database. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnyMqSession Controls a role's ability to view the security of any MQTT or MQ session. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnyMqTopic Controls a role's ability to view the security of any MQTT topic. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnyProcedureInAnyDatabase Controls a role's ability to view the security of any SQL stored procedure. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnyProcedureInOneDatabase Controls a role's ability to view the security of any SQL stored procedure in a specified database. This privilege must be explicitly permitted or denied for each database.
describeTheSecurityOfAnySequenceInAnyDatabase Controls a role's ability to view the security of any sequence. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnySequenceInOneDatabase Controls a role's ability to view the security of any sequence in a specified database. This privilege must be explicitly permitted or denied for each database.
describeTheSecurityOfAnyServer Controls a role's ability to view the security of any server in the cluster. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnySynonymInAnyDatabase Controls a role's ability to view the security of any synonym. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnySynonymInOneDatabase Controls a role's ability to view the security of any synonym in a specified database. This privilege must be explicitly permitted or denied for each database.
describeTheSecurityOfAnyTableInAnyDatabase Controls a role's ability to view the security of any table. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnyTableInOneDatabase Controls a role's ability to view the security of any table in a specified database. This privilege must be explicitly permitted or denied for each database.
describeTheSecurityOfAnyViewInAnyDatabase Controls a role's ability to view the security of any SQL view. This privilege must be explicitly permitted or denied.
describeTheSecurityOfAnyViewInOneDatabase Controls a role's ability to view the security of any SQL view in a specified database. This privilege must be explicitly permitted or denied for each database.
describeTheSecurityOfOneCodePackage Controls a role's ability to view the security of a specific code package. This privilege must be explicitly permitted or denied for each code package.
describeTheSecurityOfOneDatabase Controls a role's ability to view the security of a specific database. This privilege must be explicitly permitted or denied for each database.
describeTheSecurityOfOneMqSession Controls a role's ability to view the security of a specific MQTT or MQ session. This privilege must be explicitly permitted or denied for each MQTT or MQ session.
describeTheSecurityOfOneMqTopic Controls a role's ability to view the security of a specific MQTT topic. This privilege must be explicitly permitted or denied for each MQTT topic.
describeTheSecurityOfOneProcedure Controls a role's ability to view the security of a specific SQL stored procedure. This privilege must be explicitly permitted or denied for each SQL stored procedure.
describeTheSecurityOfOneSequence Controls a role's ability to view the security of a specific sequence. This privilege must be explicitly permitted or denied for each sequence.
describeTheSecurityOfOneSynonym Controls a role's ability to view the security of a specific synonym. This privilege must be explicitly permitted or denied for each synonym.
describeTheSecurityOfOneTable Controls a role's ability to view the security of a specific table. This privilege must be explicitly permitted or denied for each table.
describeTheSecurityOfOneView Controls a role's ability to view the security of a specific SQL view. This privilege must be explicitly permitted or denied for each SQL view.
dropAnyAccount Controls a role's ability to delete any account. This privilege must be explicitly permitted or denied.
dropAnyDatabase Controls a role's ability to delete any database. This privilege must be explicitly permitted or denied.
dropAnyProcedureInAnyDatabase Controls a role's ability to delete any SQL stored procedure. This privilege must be explicitly permitted or denied.
dropAnyProcedureInOneDatabase Controls a role's ability to delete a specific SQL stored procedure. This privilege must be explicitly permitted or denied for each procedure.
dropAnyRole Controls a role's ability to delete any role. This privilege must be explicitly permitted or denied.
dropAnySequenceInAnyDatabase Controls a role's ability to delete any sequence. This privilege must be explicitly permitted or denied.
dropAnySequenceInOneDatabase Controls a role's ability to delete any sequence in a specified database. This privilege must be explicitly permitted or denied for each database.
dropAnySynonymInAnyDatabase Controls a role's ability to delete any synonym. This privilege must be explicitly permitted or denied.

dropAnySynonymInOneDatabase

Controls a role's ability to delete any synonym in a specified database. This privilege must be explicitly permitted or denied for each database.
dropAnyTableInAnyDatabase Controls a role's ability to delete any table. This privilege must be explicitly permitted or denied.
dropAnyTableInOneDatabase Controls a role's ability to delete any table in a specified database. This privilege must be explicitly permitted or denied for each database.
dropAnyViewInAnyDatabase Controls a role's ability to delete any SQL view. This privilege must be explicitly permitted or denied.
dropAnyViewInOneDatabase Controls a role's ability to delete any SQL view in a specified database. This privilege must be explicitly permitted or denied for each database.
dropOneAccount Controls a role's ability to delete a specific account. This privilege must be explicitly permitted or denied for each account.
dropOneDatabase Controls a role's ability to delete a specific database. This privilege must be explicitly permitted or denied.
dropOneProcedure Controls a role's ability to delete a specific SQL stored procedure. This privilege must be explicitly permitted or denied.
dropOneRole Controls a role's ability to delete a specific role. This privilege must be explicitly permitted or denied.
dropOneSequence Controls a role's ability to delete a specific sequence. This privilege must be explicitly permitted or denied.
dropOneSynonym Controls a role's ability to delete a specific synonym. This privilege must be explicitly permitted or denied.
dropOneTable Controls a role's ability to delete a specific table. This privilege must be explicitly permitted or denied.
dropOneView Controls a role's ability to delete a specific SQL view. This privilege must be explicitly permitted or denied.
executeAnyCodePackageInAnyDatabase Controls a role's ability to run any code package. This privilege must be explicitly permitted or denied.
executeAnyCodePackageInOneDatabase Controls a role's ability to run any code package in a specific database. This privilege must be explicitly permitted or denied for each database.
executeAnyProcedureInAnyDatabase Controls a role's ability to run any SQL stored procedure. This privilege must be explicitly permitted or denied.
executeAnyProcedureInOneDatabase Controls a role's ability to run any SQL stored procedure in a specified database. This privilege must be explicitly permitted or denied for each database.
executeOneCodePackage Controls a role's ability to run a specific code package. This privilege must be explicitly permitted or denied for each code package.
executeOneProcedure Controls a role's ability to run a specific SQL stored procedure. This privilege must be explicitly permitted or denied for each SQL stored procedure.
insertAnyRecordInAnyTableInAnyDatabase Controls a role's ability to insert any record. This privilege must be explicitly permitted or denied.
insertAnyRecordInAnyTableInOneDatabase Controls a role's ability to insert any record in a specified database. This privilege must be explicitly permitted or denied for each database.
insertAnyRecordInOneTable Controls a role's ability to insert any record in a specified table. This privilege must be explicitly permitted or denied for each table.
linkAnyRoleWithAnyAccount Controls a role's ability to assign any role to any account. This security management privilege must be explicitly permitted or denied. Assign to a security manager who manages roles and accounts.
linkAnyRoleWithAnyPrivilege Controls a role's ability to assign any role to any privilege. This security management privilege must be explicitly permitted or denied. Assign to a security manager to control roles and their privileges.
linkOneRoleWithAnyAccount Controls a role's ability to assign a specific role to any account. This security management privilege must be explicitly permitted or denied for each role. The specified role cannot be an account's built-in role. Assign to a security manager of a specific role to control its accounts.
linkOneRoleWithAnyPrivilege Controls a role's ability to assign a specific role to any privilege. This security management privilege must be explicitly permitted or denied for each role. Assign to a security manager of a specific role to control its privileges.
listAnyCodePackageInAnyDatabase Controls a role's ability to list all code packages. This privilege must be explicitly permitted or denied.
listAnyCodePackageInOneDatabase Controls a role's ability to list all code packages in a specified database. This privilege must be explicitly permitted or denied for each database.
listTheHistoryOfAnyCodePackageInAnyDatabase Controls a role's ability to list the history of any code package. This privilege must be explicitly permitted or denied.
listTheHistoryOfAnyCodePackageInOneDatabase Controls a role's ability to list the history of any code package in a specified database. This privilege must be explicitly permitted or denied for each database.
listTheHistoryOfOneCodePackage Controls a role's ability to list the history of a specific code package. This privilege must be explicitly permitted or denied for each code package.
manageAnyAccount Controls a role's ability to perform all non-security actions on all user accounts. This security privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyCodePackageInAnyDatabase Controls a role's ability to perform all non-security actions on all code packages, including creating, modifying, reading, and cloning them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyCodePackageInOneDatabase Controls a role's ability to perform all non-security actions on all code packages in a specified database, including creating, modifying, reading, and cloning them. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each database. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyConnectorService Controls a role's ability to perform all non-security actions on all connector services, including creating, modifying, reading, and deleting them. Connector services include "modbus", "opcua", and "siemensS7". This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyDatabase Controls a role's ability to perform all non-security actions on all databases, including creating, modifying, reading, and deleting them. It also allows you to manage the SQL dictionary tables of any database. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyExternalBrokerConnection Controls a role's ability to perform all non-security actions on all external broker connections, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyMqBroker Controls a role's ability to perform all non-security actions on the MQTT broker, including creating, modifying, reading, and deleting sessions, topics, and external broker connections. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyMqSession Controls a role's ability to perform all non-security actions on all MQTT or MQ sessions, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyMqTopic Controls a role's ability to perform all non-security actions on all MQTT topics, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyProcedureInAnyDatabase Controls a role's ability to perform all non-security actions on all SQL stored procedures, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyProcedureInOneDatabase Controls a role's ability to perform all non-security actions on all SQL stored procedures in a specified database, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each database. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyRecordInAnyTableInAnyDatabase Controls a role's ability to perform all non-security actions on all records, including inserting, updating, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyRecordInAnyTableInOneDatabase Controls a role's ability to perform all non-security actions on all records in a specified database, including inserting, updating, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each database. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyRecordInOneTable Controls a role's ability to perform all non-security actions on all records in a specified table, including inserting, updating, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each table. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyRole Controls a role's ability to perform all actions on all roles, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnySequenceInAnyDatabase Controls a role's ability to perform all non-security actions on all sequences, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnySequenceInOneDatabase Controls a role's ability to perform all non-security actions on all sequences in a specified database, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each database. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyServer Controls a role's ability to perform all non-security actions on all objects in the server, including creating, modifying, reading, and deleting them. It also allows you to manage the SQL dictionary tables of any server. This privilege must be explicitly permitted or denied. A shallow denial prevents a role from having the 'manage' privilege while allowing you to grant its child privileges to the role. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnySynonymInAnyDatabase Controls a role's ability to perform all non-security actions on all synonyms, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnySynonymInOneDatabase Controls a role's ability to perform all non-security actions on all synonyms in a specified database, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each database. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyTableInAnyDatabase Controls a role's ability to perform all non-security actions on all tables, including creating, modifying, reading, and deleting a table, its indexes, its triggers, and its records. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyTableInOneDatabase Controls a role's ability to perform all non-security actions on all tables in a specified database, including creating, modifying, reading, and deleting a table, its indexes, its triggers, and its records. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each database. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyViewInAnyDatabase Controls a role's ability to perform all non-security actions on all SQL views, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageAnyViewInOneDatabase Controls a role's ability to perform all non-security actions on all SQL views in a specified database, including creating, modifying, reading, and deleting them. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each database. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneAccount Controls a role's ability to perform all actions on a specific account, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each account. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneCodePackage Controls a role's ability to perform all non-security actions on a specific code package, including modifying, reading, and cloning it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each code package. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneConnectorService Controls a role's ability to perform all non-security actions on a specific connector service, including modifying, reading, and deleting it. Connector services include "modbus", "opcua", and "siemensS7". This privilege must be explicitly permitted, recursively denied, or shallowly denied for each connector service. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneDatabase Controls a role's ability to perform all non-security actions on a specific database, including modifying, reading, and deleting it. It also allows you to manage the SQL dictionary tables of one database. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each database. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneExternalBrokerConnection Controls a role's ability to perform all non-security actions on a specific external broker connection, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each external broker connection. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneMqSession Controls a role's ability to perform all non-security actions on a specific MQTT or MQ session, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each MQTT or MQ session. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneMqTopic Controls a role's ability to perform all non-security actions on a specific MQTT topic, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each MQTT topic. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneProcedure Controls a role's ability to perform all non-security actions on a specific SQL stored procedure, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each SQL stored procedure. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneRole Controls a role's ability to perform all non-security actions on a specific role, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each role. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneSequence Controls a role's ability to perform all non-security actions on a specific sequence, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each sequence. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneSynonym Controls a role's ability to perform all non-security actions on a specific synonym, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each synonym. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneTable Controls a role's ability to perform all non-security actions on a specific table, including modifying, reading, and deleting it, its indexes, its triggers, and its records. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each table. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageOneView Controls a role's ability to perform all non-security actions on a specific SQL view, including modifying, reading, and deleting it. This privilege must be explicitly permitted, recursively denied, or shallowly denied for each SQL view. A shallow denial prevents a role from holding the 'manage' privilege, while letting you grant or deny its subordinate privileges.
manageServerDictionary Controls a role's ability to manage the server dictionary tables. This allows you to read, insert, update, and delete records as well as read table structures, modify table structures, and delete tables. This privilege must be explicitly permitted or denied. 
publishToAnyMqTopic Controls a role's ability to publish messages to all MQTT topics. This privilege must be explicitly permitted or denied.
publishToOneMqTopic Controls a role's ability to publish messages to a specific MQTT topic. This privilege must be explicitly permitted or denied for each MQTT topic.
readAnyRecordInAnyTableInAnyDatabase Controls a role's ability to read all records in all tables. This privilege must be explicitly permitted or denied.
readAnyRecordInAnyTableInOneDatabase Controls a role's ability to read all records in all tables in a specified database. This privilege must be explicitly permitted or denied for each database.
readAnyRecordInOneTable Controls a role's ability to read all records in a specific table. This privilege must be explicitly permitted or denied for each table.
readServerDictionary Controls a role's ability to read the server dictionary tables. This allows you to list the tables, read the records, and describe table structures. This privilege must be explicitly permitted or denied. 
resetThePasswordOfAnyAccount Controls a role's ability to reset the password of all accounts. This security management privilege must be explicitly permitted or denied.
resetThePasswordOfOneAccount Controls a role's ability to reset the password of a specific account. This security management privilege must be explicitly permitted or denied for each account.
revertAnyCodePackageInAnyDatabase Controls a role's ability to revert any code package to its previous state. This privilege must be explicitly permitted or denied.
revertAnyCodePackageInOneDatabase Controls a role's ability to revert any code package in a specified database to its previous state. This privilege must be explicitly permitted or denied for each database.
revertOneCodePackage Controls a role's ability to revert a specific code package to its previous state. This privilege must be explicitly permitted or denied for each code package.
subscribeToAnyMqTopic Controls a role's ability to subscribe to any MQTT topic.
subscribeToOneMqTopic Controls a role's ability to subscribe to messages to a specific MQTT topic. This privilege must be explicitly permitted or denied for each MQTT topic. The topic name cannot contain a wildcard.
updateAnyRecordInAnyTableInAnyDatabase Controls a role's ability to update all records in all tables. This privilege must be explicitly permitted or denied.
updateAnyRecordInAnyTableInOneDatabase Controls a role's ability to update all records in all tables in a specified database. This privilege must be explicitly permitted or denied for each database.
updateAnyRecordInOneTable Controls a role's ability to update all records in a specific table. This privilege must be explicitly permitted or denied for each table.
useTheValueOfAnySequenceInAnyDatabase Controls a role's ability to use the value of any sequence. This privilege must be explicitly permitted or denied.
useTheValueOfAnySequenceInOneDatabase Controls a role's ability to to use the value of any sequence in a specified database. This privilege must be explicitly permitted or denied for each database.
useTheValueOfOneSequence Controls a role's ability to use the value of a specific sequence. This privilege must be explicitly permitted or denied for each sequence.