pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
create user access only to specific tables
2+ messages / 2 participants
[nested] [flat]

* create user access only to specific tables
@ 2006-09-12 12:11 Thilina Ranaweera <tranaweera@gmail.com>
  2006-09-14 06:31 ` Re: create user access only to specific tables Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Thilina Ranaweera @ 2006-09-12 12:11 UTC (permalink / raw)
  To: pgsql-admin

I am new to PostgreSql .Please tell  me  how  to define user access only to
selected tables
Thanks

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: create user access only to specific tables
  2006-09-12 12:11 create user access only to specific tables Thilina Ranaweera <tranaweera@gmail.com>
@ 2006-09-14 06:31 ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Fuhr @ 2006-09-14 06:31 UTC (permalink / raw)
  To: Thilina Ranaweera <tranaweera@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-09-14 06:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-12 12:11 create user access only to specific tables Thilina Ranaweera <tranaweera@gmail.com>
2006-09-14 06:31 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox