Assigning Privileges To User

CREATING SUPERUSER WITH PASSWORD :

    postgres=# create user tesdbuser login superuser password 'welcome';

Create Role :

    postgres=# \du
                                    List of roles
    Role name |                         Attributes                         | Member of 
    -----------+------------------------------------------------------------+-----------
    postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
    tesdb     |                                                            | {}
    tesdbuser | Superuser

« Previous Next Topic » (Dropping user)