Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012

    Unanswered: User vs roles.......


    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 .

  2. #2
    Join Date
    Dec 2012
    I think "CREATE USER ..." is for hostorical reasons and was used in PostgreSQL pre version 8.

    The documentation of PostgreSQL 9.2 describes it:
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts