Module database_privilege_operations

Database privilege operations

This module contains functions for querying, modifying, displaying and comparing database privileges.

A lot of the complexity comes from two core components:

• The privilege editor that needs to be able to print an editable table of privileges and reparse the content after the user has made manual changes.

• The comparison functionality that tells the user what changes will be made when applying a set of changes to the list of database privileges.

Structs

• DatabasePrivilegeRow
  This struct represents the set of privileges for a single user on a single database.

Constants

• DATABASE_PRIVILEGE_FIELDS
  This is the list of fields that are used to fetch the db + user + privileges from the db table in the database. If you need to add or remove privilege fields, this is a good place to start.

Functions

• apply_privilege_diffs
  Uses the result of [diff_privileges] to modify privileges in the database.
• get_all_database_privileges
  Get all database + user + privileges pairs that are owned by the current user.
• get_databases_privilege_data
• get_mysql_row_priv_field 🔒
• unsafe_apply_privilege_diff 🔒
• unsafe_get_database_privileges 🔒
  Get all users + privileges for a single database.
• unsafe_get_database_privileges_for_db_user_pair
  Get all users + privileges for a single database-user pair.
• validate_diff 🔒