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

From pgsql-bugs@postgresql.org
Subject Bug #549: select table privilege in postgres allows user to create index on the table
Date
Msg-id 200201031612.g03GCHb47660@postgresql.org
Whole thread Raw
List pgsql-bugs
Shahid Mohammad Shamsi (mshamsi@dinmar.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
select table privilege  in postgres allows user to create index on the table

Long Description
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
problemif the user can create unique indexes. 


Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #549: select table privilege in postgres allows user to create index on the table
Next
From: Tom Lane
Date:
Subject: Re: Bug #549: select table privilege in postgres allows user to create index on the table