grant privileges

    0

    0

    lucycodes42

    SQL public snippets

    This code grants privileges to the user named ‘user_name’ on the ‘db_name’ and ‘table_name’ tables to the user localhost.

    Shortcut: s_priv_add

    
    GRANT ALL PRIVILEGES ON `db_name`.`table_name` TO 'user_name'@'localhost';
    
    
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Playground
    • Snippets
    • Cookbooks
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.