HuasoFoundries /
phpPgAdmin6
| @@ 1605-1622 (lines=18) @@ | ||
| 1602 | ||
| 1603 | // Output privileges with no GRANT OPTION |
|
| 1604 | $sql .= 'GRANT ' . join(', ', $nongrant) . " ON TABLE \"{$t->fields['relname']}\" TO "; |
|
| 1605 | switch ($v[0]) { |
|
| 1606 | case 'public': |
|
| 1607 | $sql .= "PUBLIC;\n"; |
|
| 1608 | break; |
|
| 1609 | case 'user': |
|
| 1610 | $this->fieldClean($v[1]); |
|
| 1611 | $sql .= "\"{$v[1]}\";\n"; |
|
| 1612 | break; |
|
| 1613 | case 'group': |
|
| 1614 | $this->fieldClean($v[1]); |
|
| 1615 | $sql .= "GROUP \"{$v[1]}\";\n"; |
|
| 1616 | break; |
|
| 1617 | default: |
|
| 1618 | // Unknown privilege type - fail |
|
| 1619 | $this->rollbackTransaction(); |
|
| 1620 | ||
| 1621 | return null; |
|
| 1622 | } |
|
| 1623 | ||
| 1624 | // Reset user if necessary |
|
| 1625 | if ($this->hasGrantOption() && $v[3] != $t->fields['relowner']) { |
|
| @@ 1644-1659 (lines=16) @@ | ||
| 1641 | } |
|
| 1642 | ||
| 1643 | $sql .= 'GRANT ' . join(', ', $v[4]) . " ON \"{$t->fields['relname']}\" TO "; |
|
| 1644 | switch ($v[0]) { |
|
| 1645 | case 'public': |
|
| 1646 | $sql .= 'PUBLIC'; |
|
| 1647 | break; |
|
| 1648 | case 'user': |
|
| 1649 | $this->fieldClean($v[1]); |
|
| 1650 | $sql .= "\"{$v[1]}\""; |
|
| 1651 | break; |
|
| 1652 | case 'group': |
|
| 1653 | $this->fieldClean($v[1]); |
|
| 1654 | $sql .= "GROUP \"{$v[1]}\""; |
|
| 1655 | break; |
|
| 1656 | default: |
|
| 1657 | // Unknown privilege type - fail |
|
| 1658 | return null; |
|
| 1659 | } |
|
| 1660 | $sql .= " WITH GRANT OPTION;\n"; |
|
| 1661 | ||
| 1662 | // Reset user if necessary |
|
