On 12/10/2009 01:00 PM, dipti shah wrote: > 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 http://www.postgresql.org/docs/8.4/interactive/user-manag.html this will be a good starting point --Ashish -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
