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.g03GC5c47647@postgresql.org
Whole thread Raw
Responses Re: Bug #549: select table privilege in postgres allows user to create index on the table  (Tom Lane <tgl@sss.pgh.pa.us>)
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: Dmitry Fomichev
Date:
Subject: Refcursor problem
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #549: select table privilege in postgres allows user to create index on the table