SV-253688r960960_rule
V-253688
SRG-APP-000133-DB-000200
MADB-10-002900
CAT II
10
Assign ownership of authorized objects to authorized object owner accounts.
Review system documentation to identify accounts authorized to have privileges against database objects. Review account privileges on objects in the database(s).
To show the list of system privileges that the MariaDB server supports, run:
MariaDB> SHOW PRIVILEGES;
Gather a list of SHOW GRANTS commands. SHOW GRANTS will list the privileges granted to the account.
Run this database query to create the SHOW GRANTS script for each user:
MariaDB> SELECT DISTINCT CONCAT( 'SHOW GRANTS FOR ', user,'@', host,';') AS grantQuery FROM mysql.user WHERE is_role = 'N';
Run each SHOW GRANTS command for each user.
MariaDB> SHOW GRANTS FOR 'user'@'host';
Verify that all users have the correct privileges, if they do not, this is a finding.
Only DEFINERS of routines (functions and procedures) can change routines. To view the DEFINERS of all functions and procedures, as database administrator run the following SQL:
MariaDB> SELECT * FROM mysql.proc \G
Only DEFINERS of triggers can change triggers. To view all triggers and their DEFINERS, as database administrator run the following SQL:
MariaDB> SELECT * FROM information_schema.triggers \G
If any database users are found to have unauthorized privileges on database objects, this is a finding.
V-253688
False
MADB-10-002900
Review system documentation to identify accounts authorized to have privileges against database objects. Review account privileges on objects in the database(s).
To show the list of system privileges that the MariaDB server supports, run:
MariaDB> SHOW PRIVILEGES;
Gather a list of SHOW GRANTS commands. SHOW GRANTS will list the privileges granted to the account.
Run this database query to create the SHOW GRANTS script for each user:
MariaDB> SELECT DISTINCT CONCAT( 'SHOW GRANTS FOR ', user,'@', host,';') AS grantQuery FROM mysql.user WHERE is_role = 'N';
Run each SHOW GRANTS command for each user.
MariaDB> SHOW GRANTS FOR 'user'@'host';
Verify that all users have the correct privileges, if they do not, this is a finding.
Only DEFINERS of routines (functions and procedures) can change routines. To view the DEFINERS of all functions and procedures, as database administrator run the following SQL:
MariaDB> SELECT * FROM mysql.proc \G
Only DEFINERS of triggers can change triggers. To view all triggers and their DEFINERS, as database administrator run the following SQL:
MariaDB> SELECT * FROM information_schema.triggers \G
If any database users are found to have unauthorized privileges on database objects, this is a finding.
M
5475