[MariaDB] Grant / TimeZone / Trigger / Procedure Check

2023. 11. 8. 13:51DevOps/RDBMS

# User Authority Check
SHOW GRANTS FOR 'test'@'%';

# Current Time Check
SELECT NOW(); 

# Trigger Check
SHOW TRIGGERS FROM test; # database name

# Procedure Check
SHOW PROCEDURE STATUS;

# Specific Procedure Check
SHOW PROCEDURE STATUS LIKE 'MAKE_AGW_PROPERTIES_MULTI';
--- Result...
+----------+---------------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db       | Name                      | Type      | Definer | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+----------+---------------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| xxx      | xxx                       | PROCEDURE | xxx     | 2023-11-08 09:24:44 | 2023-11-08 09:24:44 | DEFINER       |         | utf8mb3              | utf8mb3_general_ci   | utf8mb3_general_ci |
+----------+---------------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+

'DevOps > RDBMS' 카테고리의 다른 글

[MariaDB] Backup Dump File with Procedure  (1) 2023.11.08