Thread: regarding user creation
Hi
I am new to postgresql
I want to create a user account
So I tried to use “create user” command. but then it is not asking for password..User is created.
But when I want to enter the db with that user it is prompting for password.
So how do we create user with password
Please guide me..
Thanks & regards
Siva kiran.B
On 18 February 2011 00:57, Sivakiran Balijepalli <Sivakiran.Balijepalli@infor.com> wrote: > So I tried to use “create user” command. but then it is not asking for > password..User is created. > > But when I want to enter the db with that user it is prompting for password. > > So how do we create user with password Just as it says in the fine manual http://www.postgresql.org/docs/9.0/interactive/sql-createuser.html CREATE USER user WITH ENCRYPTED PASSWORD 'password'; Cheers, Andrej