| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Jean-Eric Cuendet <jean-eric(dot)cuendet(at)bluewin(dot)ch> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Permissions and PGSQL |
| Date: | 2003-12-23 15:53:03 |
| Message-ID: | 3FE864DF.70300@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> I use PgSql for a lot of our company's need and I lack some features.
> I would like to know if there is plans to implement:
> - User permissions based on columns? (Ex: User1 has Select on Column "CompayName"
> but User2 has update on column "CompanyName" while User3 has create new row
> on table).
These do not exist yet in pgsql.
> - Permissions on create table. This is the most lacking permission problem
> actually, since everyone that can log in PgSql can create tables...
This does exist. The CREATE permission on schemas is what you want.
Perhaps the CREATE permission on databases as well. You need to revoke
these from the public schema. Or even just drop the public schema.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-12-23 16:01:25 | Re: [GENERAL] Temporary tables and miscellaneous schemas |
| Previous Message | Christopher Kings-Lynne | 2003-12-23 15:49:17 | Re: Quoting of psql \d output |