Sign inTry Free
  • Introduction
    • Deploy
      • Connect to Your Cluster
        • Create a Database
          • Integrate with SingleStoreDB
            • Load Data
              • Query Data
                • Manage Data
                  • Developer Resources
                    • User and Cluster Administration
                      • Reference
                        • Configuration Reference
                          • SingleStoreDB Operator Reference
                            • SingleStore Tools Reference
                              • SQL Reference
                                • SQL Command Syntax
                                • SQL Commands List
                                • SQL Functions List
                                • Comparison Operators and Functions
                                  • Database Object Case-Sensitivity
                                  • Data Types
                                    • Character Encoding
                                      • Operations that Take Either a Database or a Cluster Level Lock
                                        • User-Defined Variables
                                          • Restricted Keywords
                                            • Aggregate Functions
                                              • Cluster Management Commands
                                                • Code Generation Functions
                                                  • Conditional Functions
                                                    • Data Definition Language DDL
                                                      • Data Manipulation Language DML
                                                        • Date and Time Functions
                                                          • Distinct Count Estimation Functions
                                                            • Full-Text Search Functions
                                                              • Geospatial Functions
                                                                • Identifier Generation Functions
                                                                  • Information Functions
                                                                    • JSON Functions
                                                                      • Numeric Functions
                                                                        • Operational Commands
                                                                          • Pipelines Commands
                                                                            • Procedural SQL Reference
                                                                              • Regular Expression Functions
                                                                                • Resource Pool Commands
                                                                                  • Security Management Commands
                                                                                    • ALTER USER
                                                                                    • CREATE GROUP
                                                                                    • CREATE LINK
                                                                                    • CREATE ROLE
                                                                                    • CREATE USER
                                                                                    • CURRENT_SECURITY_GROUPS
                                                                                    • CURRENT_SECURITY_ROLES
                                                                                    • CURRENT_USER
                                                                                    • DROP GROUP
                                                                                    • DROP LINK
                                                                                    • DROP ROLE
                                                                                    • DROP USER
                                                                                    • GRANT
                                                                                    • GRANT GROUP
                                                                                    • GRANT ROLE
                                                                                    • REVOKE
                                                                                    • REVOKE GROUP
                                                                                    • REVOKE ROLE
                                                                                    • SECURITY_LISTS_INTERSECT
                                                                                    • SET PASSWORD
                                                                                    • SHOW GRANTS
                                                                                    • SHOW GROUPS
                                                                                    • SHOW GROUPS FOR ROLE
                                                                                    • SHOW GROUPS FOR USER
                                                                                    • SHOW LINKS
                                                                                    • SHOW ROLES
                                                                                    • SHOW ROLES FOR GROUP
                                                                                    • SHOW ROLES FOR USER
                                                                                    • SHOW USERS
                                                                                    • SHOW USERS FOR GROUP
                                                                                    • SHOW USERS FOR ROLE
                                                                                    • Permissions Matrix
                                                                                    • Default Mode Permissions Changes
                                                                                    • Strict Mode Permissions
                                                                                  • SHOW Commands
                                                                                    • String Functions
                                                                                      • Time Series Functions
                                                                                        • Vector Functions
                                                                                          • Window Functions
                                                                                          • Troubleshooting Reference
                                                                                            • System Databases
                                                                                            • Information Schema Reference
                                                                                              • Data API
                                                                                                • Code Engine - Powered by Wasm
                                                                                                • Security
                                                                                                  • Release Notes
                                                                                                    • Support
                                                                                                      • Glossary
                                                                                                      1. Self-Managed v8.0
                                                                                                      2. /
                                                                                                      3. ...
                                                                                                      4. /
                                                                                                      5. Security Management Commands

                                                                                                      Security Management Commands

                                                                                                      This section contains a list of all security management commands in SingleStore. For guide material around securing SingleStore, see Learn How to Secure SingleStore.

                                                                                                      This includes RBAC permissions and commands. In this section, you can also read about the RBAC Permissions Matrix and RBAC Commands Permissions Matrix.

                                                                                                      This section also includes information about the two SingleStore permission modes - Default Mode and Strict Mode.

                                                                                                      In this section

                                                                                                      • ALTER USER
                                                                                                      • CREATE GROUP
                                                                                                      • CREATE LINK
                                                                                                      • CREATE ROLE
                                                                                                      • CREATE USER
                                                                                                      • CURRENT_SECURITY_GROUPS
                                                                                                      • CURRENT_SECURITY_ROLES
                                                                                                      • CURRENT_USER
                                                                                                      • DROP GROUP
                                                                                                      • DROP LINK
                                                                                                      • DROP ROLE
                                                                                                      • DROP USER
                                                                                                      • GRANT
                                                                                                      • GRANT GROUP
                                                                                                      • GRANT ROLE
                                                                                                      • REVOKE
                                                                                                      • REVOKE GROUP
                                                                                                      • REVOKE ROLE
                                                                                                      • SECURITY_LISTS_INTERSECT
                                                                                                      • SET PASSWORD
                                                                                                      • SHOW GRANTS
                                                                                                      • SHOW GROUPS
                                                                                                      • SHOW GROUPS FOR ROLE
                                                                                                      • SHOW GROUPS FOR USER
                                                                                                      • SHOW LINKS
                                                                                                      • SHOW ROLES
                                                                                                      • SHOW ROLES FOR GROUP
                                                                                                      • SHOW ROLES FOR USER
                                                                                                      • SHOW USERS
                                                                                                      • SHOW USERS FOR GROUP
                                                                                                      • SHOW USERS FOR ROLE
                                                                                                      • Permissions Matrix
                                                                                                      • Default Mode Permissions Changes
                                                                                                      • Strict Mode Permissions

                                                                                                      Last modified: November 17, 2022

                                                                                                      Was this article helpful?

                                                                                                      SHOW RESOURCE POOLS
                                                                                                      ALTER USER

                                                                                                      Product

                                                                                                      • Product Overview
                                                                                                      • Solutions
                                                                                                      • Pricing
                                                                                                      • Support

                                                                                                      Community

                                                                                                      • Forums
                                                                                                      • Developer Hub
                                                                                                      • Events
                                                                                                      • Training

                                                                                                      Company

                                                                                                      • Contact Us
                                                                                                      • Blog
                                                                                                      • Careers
                                                                                                      • SingleStore Connect

                                                                                                      This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

                                                                                                      • © SingleStore
                                                                                                      • |

                                                                                                      • Privacy Policy
                                                                                                      • |

                                                                                                      • Terms of Service
                                                                                                      • |

                                                                                                      • Legal Terms and Conditions

                                                                                                      Was this article helpful?