In my project Templatetiger I had in the past rights to change to db. These seems missing now:
MariaDB [s51071__templatetiger_p]> SHOW GRANTS FOR CURRENT_USER; +-----------------------------------------------------------------------------------------------------------+ | Grants for s51071@% | +-----------------------------------------------------------------------------------------------------------+ | GRANT SHOW VIEW ON *.* TO 's51071'@'%' IDENTIFIED BY PASSWORD '*8B9D50D7AC8B053001A2050BB391233F5B8FD3B6' | | GRANT ALL PRIVILEGES ON `s51071__%`.* TO 's51071'@'%' WITH GRANT OPTION | | GRANT SELECT, SHOW VIEW ON `%_p`.* TO 's51071'@'%' |
If I try to insert data, nothing happen. I can drop a table but this still exist:
MariaDB [s51071__templatetiger_p]> DROP TABLE `alswiki_neu`; Query OK, 0 rows affected (0.00 sec) MariaDB [s51071__templatetiger_p]> show tables like 'als%'; +------------------------------------------+ | Tables_in_s51071__templatetiger_p (als%) | +------------------------------------------+ | alswiki_neu | +------------------------------------------+ 1 row in set (0.00 sec)
It's a miracle for me.