creating user

From: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
To: "Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: creating user
Date: 2006-04-10 13:18:12
Message-ID: 022f01c65ca1$38471370$cd00000a@sandhyar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi...
I want to know more about alter user /creating users.I am facing error if i give user with Login/Nologin..Why is it so?
But it is working fine for Createdb/NoCreatedb.etc.

sample=# ALTER user sandhya with LOGIN;
ERROR: syntax error at or near "LOGIN" at character 25
LINE 1: ALTER user sandhya with LOGIN;

Please explain me about this/Suggest Some Manual where in i can find more about this.I have gone through postgres site.

-Sandhya

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message kevin 2006-04-10 14:49:32 Re: creating user
Previous Message sandhya 2006-04-10 09:43:38 alter column type