Postgres Pro
Downloads
Home   >   mailing lists

creating user - Mailing list pgsql-admin

From sandhya
Subject creating user
Date
Msg-id 022f01c65ca1$38471370$cd00000a@sandhyar
Whole thread Raw
Responses Re: creating user
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: "sandhya"
Date:
Subject: alter column type
Next
From: Bruce Momjian
Date:
Subject: Re: Bloated pg_shdepend_depender_index