You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
SELECT CONCAT('GRANT ALL ON ', 'openemr.',TABLE_NAME, ' to ''openemr''@''localhost'';') |
|
FROM INFORMATION_SCHEMA.TABLES |
|
WHERE TABLE_SCHEMA = 'openemr' and NOT TABLE_NAME='users_secure'; |