select table privilege in postgres allows user to create index on the table - Mailing list pgsql-bugs

From Shahid Mohammad Shamsi
Subject select table privilege in postgres allows user to create index on the table
Date
Msg-id 002401c19471$4286a460$9128a8c0@wott010024
Whole thread Raw
List pgsql-bugs
Hi,
I created a user and assigned select privilege on a table. The user can not
insert any data or add a field to the table. But, the user can create
indexes on the table despite having select only privileges. This becomes a
serious problem if the user can create unique indexes on the table where it
has select only privilege.

Can somebody update me on this, I guess other people must have noticed it.

Cheers
Shahid

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #549: select table privilege in postgres allows user to create index on the table
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Bug #549: select table privilege in postgres allows