| From: | pgsql-bugs(at)postgresql(dot)org |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug #549: select table privilege in postgres allows user to create index on the table |
| Date: | 2002-01-03 16:12:05 |
| Message-ID: | 200201031612.g03GC5c47647@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Shahid Mohammad Shamsi (mshamsi(at)dinmar(dot)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 problem if the user can create unique indexes.
Sample Code
No file was uploaded with this report
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pgsql-bugs | 2002-01-03 16:12:17 | Bug #549: select table privilege in postgres allows user to create index on the table |
| Previous Message | Shahid Mohammad Shamsi | 2002-01-03 16:11:09 | select table privilege in postgres allows user to create index on the table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-03 16:54:21 | Re: Bug #549: select table privilege in postgres allows user to create index on the table |
| Previous Message | Thomas Lockhart | 2002-01-03 15:56:23 | Re: datetime error? |