Обсуждение: create user access only to specific tables

Поиск
Список
Период
Сортировка

create user access only to specific tables

От
"Thilina Ranaweera"
Дата:
I am new to PostgreSql .Please tell  me  how  to define user access only to selected tables
Thanks

Re: create user access only to specific tables

От
Michael Fuhr
Дата:
On Tue, Sep 12, 2006 at 06:11:19PM +0600, Thilina Ranaweera wrote:
> I am new to PostgreSql .Please tell  me  how  to define user access only to
> selected tables

See the GRANT and REVOKE commands.

http://www.postgresql.org/docs/8.1/interactive/ddl-priv.html
http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
http://www.postgresql.org/docs/8.1/interactive/sql-revoke.html

--
Michael Fuhr