HuasoFoundries /
phpPgAdmin6
| @@ 8027-8038 (lines=12) @@ | ||
| 8024 | * |
|
| 8025 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 8026 | */ |
|
| 8027 | public function grantRole($role, $rolename, $admin = 0) |
|
| 8028 | { |
|
| 8029 | $this->fieldClean($role); |
|
| 8030 | $this->fieldClean($rolename); |
|
| 8031 | ||
| 8032 | $sql = "GRANT \"{$role}\" TO \"{$rolename}\""; |
|
| 8033 | if ($admin == 1) { |
|
| 8034 | $sql .= ' WITH ADMIN OPTION'; |
|
| 8035 | } |
|
| 8036 | ||
| 8037 | return $this->execute($sql); |
|
| 8038 | } |
|
| 8039 | ||
| 8040 | /** |
|
| 8041 | * Revokes membership in a role. |
|
| @@ 8050-8063 (lines=14) @@ | ||
| 8047 | * |
|
| 8048 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 8049 | */ |
|
| 8050 | public function revokeRole($role, $rolename, $admin = 0, $type = 'RESTRICT') |
|
| 8051 | { |
|
| 8052 | $this->fieldClean($role); |
|
| 8053 | $this->fieldClean($rolename); |
|
| 8054 | ||
| 8055 | $sql = 'REVOKE '; |
|
| 8056 | if ($admin == 1) { |
|
| 8057 | $sql .= 'ADMIN OPTION FOR '; |
|
| 8058 | } |
|
| 8059 | ||
| 8060 | $sql .= "\"{$role}\" FROM \"{$rolename}\" {$type}"; |
|
| 8061 | ||
| 8062 | return $this->execute($sql); |
|
| 8063 | } |
|
| 8064 | ||
| 8065 | /** |
|
| 8066 | * Removes a role. |
|
