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.
 
 
 
 
 
 

3 lines
193 B

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';