Nasty security bug with clustering

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Nasty security bug with clustering
Дата
Msg-id 408F4656.2070508@familyhealth.com.au
обсуждение исходный текст
Ответы Re: Nasty security bug with clustering  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
No check is performed for being a superuser, the table owner or that it 
is a system table when marking an index for clustering:

usa=> alter table pg_class cluster on "pg_class_oid_index";
ALTER TABLE
usa=> select oid from pg_class where relname='pg_class_oid_index';  oid
------- 16613
(1 row)

usa=> select * from pg_index where indexrelid=16613; indexrelid | indrelid | indkey | indclass | indnatts | indisunique
|
 
indisprimary | indisclustered | indexprs | indpred

------------+----------+--------+----------+----------+-------------+--------------+----------------+----------+---------
    16613 |     1259 | -2     |     1989 |        1 | t           | f            | t              |          |
 
(1 row)

Note how I managed to mark as clustered an index on a system catalog as 
a non-superuser...

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.5 features
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Clustering system catalog indexes