create users

Hi,
I am using enterprisedb8.3 version.
In that how to create users ?
how to give permissions for a particular user?

Regards,
Kiran

Read the documentation

http://www.enterprisedb.com/documentation/app-createuser.html

I have tried to create an additional user using the SQL shell (psql). The following command was:

CREATE USER username NOSUPERUSER CREATEDB NOCREATEUSER PASSWORD 'password'

I tried to log in under the SQL shell (psql), the result was as follows:

runpsql.sh; exit
Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]: username
Password for user colemanreg:
psql: FATAL: password authentication failed for user "username"

Please, I require some assistance

psql: FATAL: password authentication failed for user "username"

Error Message says that you have passed wrong password.

If you remember the password then pass the right password.

One more thing... Have u been able to create user successfully?
If you forgot the password, please mention so. I will give u the steps to recover it.

Thank you for you response, I appreciate all the help I can get with this.

No, I have not been able to create a user successfully, at this time.

I have also, tried the following query also:
postgres=#
postgres=# CREATE USER username WITH PASSWORD 'some password' CREATEDB NOSUPERUSER ;
CREATE ROLE

Should the "username" be in single quotes?

But, when I try to login in the sql Shell window I get the same result. This is getting a little frustrating because I don't
want to have to build every data base as the root "postgres" user.

I have even pasted the password into the window , still no luck...

Following is a sanpshot which would help you:
1. Connect to database using psql as given below:
psql -U postgres -p 5432 postgres

2. Create user as given below:

3. Exit from the psql using \q command as given below:

4. Now connect with the Database: postgres, as username as given below:

When psql prompt then, you have to pass password: some password

Please let me know if above is helpful.. Or if you need some more snapshots.

Thank You, Thank You, Thank You!!!

Here are the results:

Last login: Tue Jul 6 16:51:24 on ttyp1
Welcome to Darwin!
You have new mail.
reginald-colemans-powerbook-g4-12:~ colemanreg$ /Library/PostgreSQL/8.4/scripts/runpsql.sh; exit
Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]: psql -U postgres -p 5432 postgres
psql: warning: extra command-line argument "postgres" ignored
Password for user postgres:
psql (8.4.4)
Type "help" for help.

postgres=# CREATE USER mynewuser WITH PASSWORD 'some Password' CREATEDB NOSUPERUSER ;
CREATE ROLE
postgres=#
postgres=# \q
logout
[Process completed]

[17:25:39:Tue Jul 06]> /usr/local/bin/psql -U mynewuser -p 5432 postgres
Password for user mynewuser:
Welcome to psql 8.2.3 (server 8.4.4), the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

WARNING: You are connected to a server with major version 8.4,
but your psql client is major version 8.2. Some backslash commands,
such as \d, might not work properly.

postgres=> \q
[17:49:17:Tue Jul 06]> /Library/PostgreSQL/8.4/bin/psql -U mynewuser -p 5432 postgres
Password for user mynewuser:
psql (8.4.4)
Type "help" for help.

postgres=>

When I realized that I still had the client from the "Marc Liyanage" PostgreSQL installation I logged out and
then logged in under the EnterpriseDB installation.

I appreciate the help!!! Again, THANK YOU!!!

This message was edited 2 times. Last update was at 12 Jul 2010 01:17:37

How can i find the password of a super user if I forget the password after creating the user when i was using the redhat linux version.

Please give me the reply....