2,306
edits
Changes
Jump to navigation
Jump to search
Line 66:
Line 66: − The following step-by-step will let you create a user, a database (DB) and grant full access to the user to this DB.<br />+ − <br />+ − − − All the commands are executed as the postgres privileged user. − Create the user<br /> − <br /> − − − For this, you use the command createuser which is provides with the postgreSQL package. Then answer the questions as you see fit :<br /> − <br /> − − postgres@hostname:~$ createuser Line 85:
Line 74: − postgres@hostname:~$ − Create the DB − − Use the createdb command to create the database : + − Grand access for the user to the DB − − And last, using the psql command, set a password for the user and grant accesses : +
→Create user, database and password
== Create user, database and password ==
== Create user, database and password ==
* Create the user<br />
postgres@hostname:~$ createuser
Enter name of role to add: username
Enter name of role to add: username
Shall the new role be a superuser? (y/n) n
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
CREATE ROLE
CREATE ROLE
* Create the DB
postgres@hostname:~$ createdb databasename
postgres@hostname:~$ createdb databasename
CREATE DATABASE
CREATE DATABASE
postgres@hostname:~$
postgres@hostname:~$
* Grant access for the user to the DB
postgres@hostname:~$ psql
postgres@hostname:~$ psql
postgres=# alter user username with encrypted password 'password';
postgres=# alter user username with encrypted password 'password';