newbie : setting access for users in a web enviroment

Поиск
Список
Период
Сортировка
От robert mena
Тема newbie : setting access for users in a web enviroment
Дата
Msg-id 528f47680512231306m14252e04w6392863b668f81f@mail.gmail.com
обсуждение исходный текст
Ответы Re: newbie : setting access for users in a web enviroment  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
Hi,

I am new to postgres but coming from a MySQL enviroment.

I am confused with the necessary steps to create users and restrict them to access/delete/insert/update data and create/delete/alter tables in a specific database.

I've created a database test and a user testadm

createdb test

createuser -D -P testadm
Enter password for new user:
Enter it again:
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER

psql test
\du
                         List of users
   User name    | User ID |         Attributes         | Groups
----------------+---------+----------------------------+--------
 testadm |     100 |                            |
 postgres       |       1 | superuser, create database |

GRANT CREATE,REFERENCES ON DATABASE test TO testadm;

\z
Access privileges for database "test"
 Schema | Name | Type | Access privileges
--------+------+------+-------------------

How can I specify that the user testadm can perform those actions to this database?

Tks.

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Adler
Дата:
Сообщение: Re: HINT: Perhaps out of disk space?
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: newbie : setting access for users in a web enviroment