Re: (unknown)

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: (unknown)
Date: 2011-02-17 12:24:52
Message-ID: ijj42k$gnu$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

siva kiran balijepalli, 17.02.2011 13:10:
> 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..

Check out the manual, it's all explained there.

The syntax is: CREATE USER newuser PASSWORD 'verysecret';

http://www.postgresql.org/docs/current/static/sql-createuser.html

Regards
Thomas

In response to

  • at 2011-02-17 12:10:04 from siva kiran balijepalli

Browse pgsql-novice by date

  From Date Subject
Next Message Andrej 2011-02-17 16:16:13 Re: regarding user creation
Previous Message Jean-Yves F. Barbier 2011-02-17 12:21:39 Re: