Re: [GENERAL] Other user access to database

Поиск
Список
Период
Сортировка
От Bryan White
Тема Re: [GENERAL] Other user access to database
Дата
Msg-id 004d01be22f5$96a23fa0$a3f0f6ce@bryan.arcamax.com
обсуждение исходный текст
Список pgsql-general
>Now that I have a database functional, I need to allow other users
>to have access.  Using createuser I can give other users access to
>the postmaster, but I need to give them access to my database as well.
>
>Could someone enlighten me.


Access to tables is controled with the Grant and Revoke SQL statements.

From memory try:
    grant OPERATION on TABLENAME to USER;

where

OPERATION is one of SELECT, UPDATE, DELETE, INSERT or ALL for all
operations.

TABLENAME is a comma separated list of tables.

USER is a comma separated list of users or the keyword PUBLIC.


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

Предыдущее
От: "Chris Williams"
Дата:
Сообщение: Error with table that exists but postgres says it doesn't
Следующее
От: Bob Dusek
Дата:
Сообщение: Re: [GENERAL] Other user access to database