What Is the Difference Between Role and User in Postgresql

Users, groups, and roles are the same thing in PostgreSQL, with the only difference being that users have permission to log in by default. … The roles are used only to group grants and other roles. This role can then be assigned to one or more users to grant them all the permissions.

What is the difference between role and user?

A role typically defines a business function (or set of functions) performed by one or more users. Examples would be ‘customer service agent’ or ‘business analyst’. A user is an individual person who is included in the role – Bob, Nancy, and Steve might be assigned to the customer service agent role.

What is user in PostgreSQL?

gcloud sql users set-password postgres \ –instance= INSTANCE_NAME \ –password= PASSWORD. The postgres user is part of the cloudsqlsuperuser role, and has the following attributes (privileges): CREATEROLE , CREATEDB , and LOGIN . It does not have the SUPERUSER or REPLICATION attributes.