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.5
                                    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?