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
                      • Security
                        • Overview
                          • Configure SingleStoreDB User Accounts
                            • Secure the Initial SingleStoreDB User Accounts
                            • Add a User
                            • Change a Password for a User
                            • Remove a User
                            • Inspect Permissions
                            • Set a Failed Login Attempt Lockout Policy
                          • Configuring Host-Based Security
                          • Setting SECURE_FILE_PRIV
                        • Authentication
                          • Administration
                            • Audit Logging
                              • Encryption
                              • Release Notes
                                • Support
                                  • Glossary
                                  1. Self-Managed v7.3
                                  2. /
                                  3. ...
                                  4. /
                                  5. Inspect Permissions

                                  Inspect Permissions

                                  You can view grants and permissions by querying information_schema.user_privileges.

                                  You can also view grants for a user by running SHOW GRANTS:

                                  SHOW GRANTS FOR user@domain;

                                  Last modified: January 20, 2023

                                  Was this article helpful?

                                  Remove a User
                                  Set a Failed Login Attempt Lockout Policy

                                  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?