如何在postgresql中为db创建用户？ [关闭]

2 回答

• 295

  来自CLI：

  $ su - postgres 
  $ psql template1
  template1=# CREATE USER tester WITH PASSWORD 'test_password';
  template1=# GRANT ALL PRIVILEGES ON DATABASE "test_database" to tester;
  template1=# \q
  

  PHP（在localhost上测试，它按预期工作）：

  $connString = 'port=5432 dbname=test_database user=tester password=test_password';
    $connHandler = pg_connect($connString);
    echo 'Connected to '.pg_dbname($connHandler);
  

  回复于 2024-04-29T20:33:27+08:00
• 38

  使用密码创建用户：

  http://www.postgresql.org/docs/current/static/sql-createuser.html

  CREATE USER name [ [ WITH ] option [ ... ] ]
  
  where option can be:
  
        SUPERUSER | NOSUPERUSER
      | CREATEDB | NOCREATEDB
      | CREATEROLE | NOCREATEROLE
      | CREATEUSER | NOCREATEUSER
      | INHERIT | NOINHERIT
      | LOGIN | NOLOGIN
      | REPLICATION | NOREPLICATION
      | CONNECTION LIMIT connlimit
      | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
      | VALID UNTIL 'timestamp'
      | IN ROLE role_name [, ...]
      | IN GROUP role_name [, ...]
      | ROLE role_name [, ...]
      | ADMIN role_name [, ...]
      | USER role_name [, ...]
      | SYSID uid
  

  然后授予特定数据库的用户权限：

  http://www.postgresql.org/docs/current/static/sql-grant.html

  示例：

  grant all privileges on database db_name to someuser;
  

  回复于 2024-04-29T20:33:27+08:00