- Notifications
You must be signed in to change notification settings - Fork5
Commit7bae5a2
committed
Get rid of the separate RULE privilege for tables: now only a table's owner
can create or modify rules for the table. Do setRuleCheckAsUser() whileloading rules into the relcache, rather than when defining a rule. Thisensures that permission checks for tables referenced in a rule are done withrespect to the current owner of the rule's table, whereas formerly ALTER TABLEOWNER would fail to update the permission checking for associated rules.Removal of separate RULE privilege is needed to prevent various scenariosin which a grantee of RULE privilege could effectively have any privilegeof the table owner. For backwards compatibility, GRANT/REVOKE RULE is stillaccepted, but it doesn't do anything. Per discussion here:http://archives.postgresql.org/pgsql-hackers/2006-04/msg01138.php1 parentd5eb52a commit7bae5a2
File tree
21 files changed
+113
-155
lines changed- doc/src/sgml
- ref
- src
- backend
- catalog
- commands
- rewrite
- utils
- adt
- cache
- include
- catalog
- nodes
- rewrite
- utils
- test/regress
- expected
- sql
21 files changed
+113
-155
lines changedLines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 |
| - | |
| 1 | + | |
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
| |||
1342 | 1342 |
| |
1343 | 1343 |
| |
1344 | 1344 |
| |
1345 |
| - | |
| 1345 | + | |
1346 | 1346 |
| |
1347 | 1347 |
| |
1348 | 1348 |
| |
|
Lines changed: 5 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 |
| - | |
| 1 | + | |
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
| |||
9543 | 9543 |
| |
9544 | 9544 |
| |
9545 | 9545 |
| |
9546 |
| - | |
9547 |
| - | |
9548 |
| - | |
| 9546 | + | |
| 9547 | + | |
| 9548 | + | |
| 9549 | + | |
9549 | 9550 |
| |
9550 | 9551 |
| |
9551 | 9552 |
| |
|
Lines changed: 3 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 |
| - | |
| 1 | + | |
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
| |||
2832 | 2832 |
| |
2833 | 2833 |
| |
2834 | 2834 |
| |
2835 |
| - | |
| 2835 | + | |
2836 | 2836 |
| |
2837 | 2837 |
| |
2838 | 2838 |
| |
| |||
4418 | 4418 |
| |
4419 | 4419 |
| |
4420 | 4420 |
| |
4421 |
| - | |
| 4421 | + | |
4422 | 4422 |
| |
4423 | 4423 |
| |
4424 | 4424 |
| |
|
Lines changed: 2 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 | 1 |
| |
2 |
| - | |
| 2 | + | |
3 | 3 |
| |
4 | 4 |
| |
5 | 5 |
| |
| |||
200 | 200 |
| |
201 | 201 |
| |
202 | 202 |
| |
203 |
| - | |
204 |
| - | |
| 203 | + | |
205 | 204 |
| |
206 | 205 |
| |
207 | 206 |
| |
|
Lines changed: 7 additions & 19 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 | 1 |
| |
2 |
| - | |
| 2 | + | |
3 | 3 |
| |
4 | 4 |
| |
5 | 5 |
| |
| |||
20 | 20 |
| |
21 | 21 |
| |
22 | 22 |
| |
23 |
| - | |
| 23 | + | |
24 | 24 |
| |
25 | 25 |
| |
26 | 26 |
| |
| |||
178 | 178 |
| |
179 | 179 |
| |
180 | 180 |
| |
181 |
| - | |
182 |
| - | |
183 |
| - | |
184 |
| - | |
185 |
| - | |
186 |
| - | |
187 |
| - | |
188 |
| - | |
189 |
| - | |
190 |
| - | |
191 | 181 |
| |
192 | 182 |
| |
193 | 183 |
| |
| |||
418 | 408 |
| |
419 | 409 |
| |
420 | 410 |
| |
421 |
| - | |
422 |
| - | |
| 411 | + | |
| 412 | + | |
423 | 413 |
| |
424 | 414 |
| |
425 | 415 |
| |
| |||
432 | 422 |
| |
433 | 423 |
| |
434 | 424 |
| |
435 |
| - | |
436 | 425 |
| |
437 | 426 |
| |
438 | 427 |
| |
439 | 428 |
| |
440 | 429 |
| |
441 | 430 |
| |
442 | 431 |
| |
443 |
| - | |
| 432 | + | |
444 | 433 |
| |
445 | 434 |
| |
446 | 435 |
| |
| |||
463 | 452 |
| |
464 | 453 |
| |
465 | 454 |
| |
466 |
| - | |
| 455 | + | |
467 | 456 |
| |
468 | 457 |
| |
469 | 458 |
| |
| |||
548 | 537 |
| |
549 | 538 |
| |
550 | 539 |
| |
551 |
| - | |
552 |
| - | |
| 540 | + | |
553 | 541 |
| |
554 | 542 |
| |
555 | 543 |
| |
|
Lines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 | 1 |
| |
2 |
| - | |
| 2 | + | |
3 | 3 |
| |
4 | 4 |
| |
5 | 5 |
| |
| |||
21 | 21 |
| |
22 | 22 |
| |
23 | 23 |
| |
24 |
| - | |
| 24 | + | |
25 | 25 |
| |
26 | 26 |
| |
27 | 27 |
| |
|
Lines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 |
| - | |
| 1 | + | |
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
| |||
293 | 293 |
| |
294 | 294 |
| |
295 | 295 |
| |
296 |
| - | |
| 296 | + | |
297 | 297 |
| |
298 | 298 |
| |
299 | 299 |
| |
|
Lines changed: 3 additions & 5 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
1328 | 1328 |
| |
1329 | 1329 |
| |
1330 | 1330 |
| |
1331 |
| - | |
1332 |
| - | |
1333 | 1331 |
| |
1334 | 1332 |
| |
1335 | 1333 |
| |
| |||
1346 | 1344 |
| |
1347 | 1345 |
| |
1348 | 1346 |
| |
| 1347 | + | |
| 1348 | + | |
1349 | 1349 |
| |
1350 | 1350 |
| |
1351 | 1351 |
| |
| |||
1365 | 1365 |
| |
1366 | 1366 |
| |
1367 | 1367 |
| |
1368 |
| - | |
1369 |
| - | |
1370 | 1368 |
| |
1371 | 1369 |
| |
1372 | 1370 |
| |
|
Lines changed: 1 addition & 8 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
4 | 4 |
| |
5 | 5 |
| |
6 | 6 |
| |
7 |
| - | |
| 7 | + | |
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
| |||
1194 | 1194 |
| |
1195 | 1195 |
| |
1196 | 1196 |
| |
1197 |
| - | |
1198 | 1197 |
| |
1199 | 1198 |
| |
1200 | 1199 |
| |
| |||
1705 | 1704 |
| |
1706 | 1705 |
| |
1707 | 1706 |
| |
1708 |
| - | |
1709 | 1707 |
| |
1710 | 1708 |
| |
1711 | 1709 |
| |
| |||
1739 | 1737 |
| |
1740 | 1738 |
| |
1741 | 1739 |
| |
1742 |
| - | |
1743 | 1740 |
| |
1744 | 1741 |
| |
1745 | 1742 |
| |
| |||
1785 | 1782 |
| |
1786 | 1783 |
| |
1787 | 1784 |
| |
1788 |
| - | |
1789 | 1785 |
| |
1790 | 1786 |
| |
1791 | 1787 |
| |
| |||
1841 | 1837 |
| |
1842 | 1838 |
| |
1843 | 1839 |
| |
1844 |
| - | |
1845 | 1840 |
| |
1846 | 1841 |
| |
1847 | 1842 |
| |
| |||
1963 | 1958 |
| |
1964 | 1959 |
| |
1965 | 1960 |
| |
1966 |
| - | |
1967 | 1961 |
| |
1968 | 1962 |
| |
1969 | 1963 |
| |
| |||
2162 | 2156 |
| |
2163 | 2157 |
| |
2164 | 2158 |
| |
2165 |
| - | |
2166 | 2159 |
| |
2167 | 2160 |
| |
2168 | 2161 |
| |
|
Lines changed: 3 additions & 5 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
7 | 7 |
| |
8 | 8 |
| |
9 | 9 |
| |
10 |
| - | |
| 10 | + | |
11 | 11 |
| |
12 | 12 |
| |
13 | 13 |
| |
| |||
741 | 741 |
| |
742 | 742 |
| |
743 | 743 |
| |
744 |
| - | |
745 | 744 |
| |
746 | 745 |
| |
747 | 746 |
| |
| |||
819 | 818 |
| |
820 | 819 |
| |
821 | 820 |
| |
822 |
| - | |
823 |
| - | |
824 |
| - | |
| 821 | + | |
| 822 | + | |
825 | 823 |
| |
826 | 824 |
| |
827 | 825 |
| |
|
0 commit comments
Comments
(0)