Re: User Permission - Mailing list pgsql-sql

> > Dear group,
> >    i created a user named 'dataviewer' and grant only select permission to
> > that user,
> >    but now the user could able to create tables. how to restrict this,
> >    i want to give permission to create views and do selects on tables and
> > views.
> >    how to do it?
> >    plz help.
> Have your checked
> http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
> http://www.postgresql.org/docs/8.1/interactive/sql-revoke.html
> I would start by creating a role:
> http://www.postgresql.org/docs/8.1/interactive/user-manag.html
> And revoke all on it.  Then add only the permissions it needs and assign the
> role to the user.

Also, one additional point would be to revoke all from public as mentioned in the following
thread:
http://archives.postgresql.org/pgsql-general/2006-07/msg00148.php

Apparently, whatever privileges 'pubic' has are extended to the privileges of the individual
users.

Regards,

Richard Broersma Jr.