Re: [ADMIN] creating user

2006-04-10 Thread kevin
On Monday 10 April 2006 07:18, sandhya wrote: > 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

[ADMIN] creating user

2006-04-10 Thread sandhya
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 25LINE 1: ALTER user