> 1) create one user with password and all Grant on Database. it is a admin
> user
The below steps would help:
$ su - postgres
$ createuser your_user
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
Use GRANT
Hi All
i am new on Postgresql7.3. so please
help.
i have create one(ICPS) Database with
Postgre user and password is NULL.
now i want to
1) create one user with password and
all Grant on Database. it is a admin user
2) i want to add password to postgres
user.
Please Help
Ramesh Patel