Re: [ADMIN] Add user on old database with password

2003-06-13 Thread A.Bhuvaneswaran
> 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

[ADMIN] Add user on old database with password

2003-06-12 Thread Ramesh PAtel
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