[MariaDB] Grant / TimeZone / Trigger / Procedure Check
2023. 11. 8. 13:51ㆍDevOps/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 |
---|