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