Thread: permissions?

permissions?

From
Marc Britten
Date:
hi again,

I'm looking through all the docs i can find, and I don't see much about
setting permissions outside of the basic adding users stuff, I added several
users and the ones w/ create db rights can access the database just fine,
all others get permission denied when trying to select from tables/views.

what do i do to setup perms? or where can i find this info? neither the
supplied docs seem to talk about this nor the book thats on the website

marc britten

Re: permissions?

From
Mike Mascari
Date:
Marc Britten wrote:
>
> hi again,
>
> I'm looking through all the docs i can find, and I don't see much about
> setting permissions outside of the basic adding users stuff, I added several
> users and the ones w/ create db rights can access the database just fine,
> all others get permission denied when trying to select from tables/views.
>
> what do i do to setup perms? or where can i find this info? neither the
> supplied docs seem to talk about this nor the book thats on the website
>
> marc britten

This link may do it for you:

http://www.postgresql.org/docs/postgres/sql-grant.htm

Hope that helps,

Mike Mascari