PostgreSQL Kullanıcı Oluşturma, Silme ve Yetkilendirme

$psql
=# create user kullanici_adi with encrypted password 'şifre';
CREATE ROLE

=# grant all privileges on database database_adi to kullanici_adi;
GRANT

=#  DROP USER kullanici_adi;
DROP ROLE

    postgres@pythontr:~$ createuser -P user_name
    Enter password for new role:
    Enter it again:
    Shall the new role be a superuser? (y/n) n
    Shall the new role be allowed to create databases? (y/n) y
    Shall the new role be allowed to create more new roles? (y/n) n

    postgres@pythontr:~$ createdb -O user_name database

    postgres@pythontr:~$ psql -U user_name -h 127.0.0.1 database