Defining permissions for tables, schema etc.. - Mailing list pgsql-general

From dipti shah
Subject Defining permissions for tables, schema etc..
Date
Msg-id d5b05a950912092330n23031473re258808aaf68ae60@mail.gmail.com
Whole thread Raw
Responses Re: Defining permissions for tables, schema etc..  (Ashish Karalkar <ashish.karalkar@netcore.co.in>)
Re: Defining permissions for tables, schema etc..  (John R Pierce <pierce@hogranch.com>)
Re: Defining permissions for tables, schema etc..  (Craig Ringer <craig@postnewspapers.com.au>)
List 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

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Install compat-postgresql-libs-debuginfo on postgres 8.3.8 without using RPM
Next
From: Postgre Novice
Date:
Subject: Fw: ERROR: could not open relation with OID 59132