From: | dipti shah <shahdipti1980(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Defining permissions for tables, schema etc.. |
Date: | 2009-12-10 07:30:29 |
Message-ID: | d5b05a950912092330n23031473re258808aaf68ae60@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
We have started using PostGreSQL for more than 3 months and it looks
awesome. Currently, we have been suing superuser by default as login
account. Now, the users are getting increased and we want to go away with
using superuser by default. We want to create the separate user account for
every users and want to define the permission for each of them. For example,
we want particular user cannot create schema, he can create tables only in
particular schema, he can updates only few tables and also updates only few
columns etc. In short, we want to define all available permission options. I
am not aware of anything starting from creating new user account to
assigning column level permissions. Could anyone please help me to start
with this. What is the best way to start?
Thanks,
Dipti
From | Date | Subject | |
---|---|---|---|
Next Message | Postgre Novice | 2009-12-10 07:34:39 | Fw: ERROR: could not open relation with OID 59132 |
Previous Message | Devrim GÜNDÜZ | 2009-12-10 06:33:51 | Re: [GENERAL] Install compat-postgresql-libs-debuginfo on postgres 8.3.8 without using RPM |