Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    6

    Unanswered: Newbie question: Postgresql user

    Hi,
    I have some knowledge of mySQL.
    I want to try PostgreSQL, but I don't understand how user management work.

    In mySQL I need to create a user who has access to create a database, table, etc.. I do this in mySQL:

    Code:
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
        ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
        ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
    mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
    mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
    PostgreSQL has the same idea? The super administrator need to create a separate user account for each user? Which PostgreSQL command help me to achieve this goal ?

    Thank you very much !

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    PostgreSQL has a more advanced approach called Roles.

    ref http://www.postgresql.org/docs/8.1/s...ser-manag.html
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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