User vs roles.......

nnani · #1 (**permalink**) 12-12-12, 01:21

Hello,

I know this may sound a dumb question. But I am very new to PostgreSQL and very confused with the concepts of USER and ROLES.

Please help me to clarify this concept. What is basic difference of USER and ROLES. and also Difference between createuser wrapper, Create user (SQL) and Create ROLE Login( SQL).

Thanks in advance .

bibjet · #2 (**permalink**) 12-25-12, 20:05

I think "CREATE USER ..." is for hostorical reasons and was used in PostgreSQL pre version 8.

The documentation of PostgreSQL 9.2 describes it:

Quote:

CREATE USER is now an alias for CREATE ROLE. The only difference is that when the command is spelled CREATE USER, LOGIN is assumed by default, whereas NOLOGIN is assumed when the command is spelled CREATE ROLE.

On both commands SQL "CREATE USER ..." and the external program "createuser" the new user is allowed to login.

Internet Services

Web Development

Digital Marketing

Consumer Tech