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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 3 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedFeb 17, '11 at 12:10p
activeFeb 17, '11 at 12:25p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase