repo.or.cz
/
openemr.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
consolidate attr_url function (#2143)
[openemr.git]
/
Documentation
/
privileged_db
/
generate_table_permissions_script.sql
blob
f1bd40ddb21bcd17f9beca0ac070115d5e71dd5d
1
SELECT CONCAT('GRANT ALL ON ', 'openemr.',TABLE_NAME, ' to ''openemr''@''localhost'';')
2
FROM INFORMATION_SCHEMA.TABLES
3
WHERE TABLE_SCHEMA = 'openemr' and NOT TABLE_NAME='users_secure';