The privilege hierarchy mirrors the server object hierarchy.
- Server
- Database
- Table
- Field
- Record
- Index
- CodePackage
- Procedure
- Sequence
- Synonym
- Trigger
- View
- Table
- Backup
- Connection
- ConnectorService
- MqBroker
- MqSession
- MqTopic
- ExternalBrokerConnection
- Replication
- Database
The security privilege hierarchy is separate from the server hierarchy.
- Server
- Account
- 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. |
|
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. |