🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
information_schema
Nivel actual
🧬 Columnas: information_schema / SCHEMA_PRIVILEGES
5| Campo | Tipo | Null | Key | Default | Extra |
|---|
| GRANTEE | varchar(385) | NO | | | |
| TABLE_CATALOG | varchar(512) | NO | | | |
| TABLE_SCHEMA | varchar(64) | NO | | | |
| PRIVILEGE_TYPE | varchar(64) | NO | | | |
| IS_GRANTABLE | varchar(3) | NO | | | |
🔬 Muestra de datos
20 filas
| GRANTEE | TABLE_CATALOG | TABLE_SCHEMA | PRIVILEGE_TYPE | IS_GRANTABLE |
|---|
| 'cueva'@'localhost' | def | cueva_test | SELECT | NO |
| 'cueva'@'localhost' | def | cueva_test | INSERT | NO |
| 'cueva'@'localhost' | def | cueva_test | UPDATE | NO |
| 'cueva'@'localhost' | def | cueva_test | DELETE | NO |
| 'cueva'@'localhost' | def | cueva_test | CREATE | NO |
| 'cueva'@'localhost' | def | cueva_test | DROP | NO |
| 'cueva'@'localhost' | def | cueva_test | REFERENCES | NO |
| 'cueva'@'localhost' | def | cueva_test | INDEX | NO |
| 'cueva'@'localhost' | def | cueva_test | ALTER | NO |
| 'cueva'@'localhost' | def | cueva_test | CREATE TEMPORARY TABLES | NO |
| 'cueva'@'localhost' | def | cueva_test | LOCK TABLES | NO |
| 'cueva'@'localhost' | def | cueva_test | EXECUTE | NO |
| 'cueva'@'localhost' | def | cueva_test | CREATE VIEW | NO |
| 'cueva'@'localhost' | def | cueva_test | SHOW VIEW | NO |
| 'cueva'@'localhost' | def | cueva_test | CREATE ROUTINE | NO |
| 'cueva'@'localhost' | def | cueva_test | ALTER ROUTINE | NO |
| 'cueva'@'localhost' | def | cueva_test | EVENT | NO |
| 'cueva'@'localhost' | def | cueva_test | TRIGGER | NO |
| 'cueva'@'localhost' | def | cueva_test | DELETE HISTORY | NO |
| 'cueva'@'localhost' | def | cueva_test | SHOW CREATE ROUTINE | NO |