show grants

    0

    1

    lucycodes42

    SQL public snippets

    The following code displays all grants for the user name "user_name" from the localhost server.

    Shortcut: s_priv_list

    
    SHOW GRANTS FOR 'user_name'@'localhost'\G
    
    
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Playground
    • Snippets
    • Cookbooks
    Legal
    • Security
    • Privacy Policy
    • Code Privacy
    • Terms of Service
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.