Revision 9634
Added by Aaron Marcuse-Kubitza over 11 years ago
| lib/sh/db.sh | ||
|---|---|---|
| 203 | 203 |
mysql_seal_table() # usage: table=... user=... mysql_seal_table |
| 204 | 204 |
# prevents further modifications to a table by a user |
| 205 | 205 |
{
|
| 206 |
echo_func; kw_params table user; : "${table:?}" "${user:?}"
|
|
| 207 |
set_database; mk_table_esc |
|
| 206 |
echo_func; kw_params table user; : "${table:?}" "${user:?}"; mk_table_esc
|
|
| 208 | 207 |
|
| 209 |
mysql_root <<<"REVOKE ALL PRIVILEGES ON $database.$table FROM '$user'@'%'"
|
|
| 208 |
mysql_root <<<"REVOKE ALL PRIVILEGES ON $table FROM '$user'@'%'" |
|
| 210 | 209 |
} |
| 211 | 210 |
|
| 212 | 211 |
|
Also available in: Unified diff
lib/sh/db.sh: mysql_seal_table(): REVOKE: removed unneeded explicit database since this is automatically set to the current database