Roles and privileges?

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Roles and privileges?
Date: 2008-07-25 14:30:04
Message-ID: 4E99090C-5EB8-473F-94D5-83E1362F30C7@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings one and all,

I've been working a lot with roles and privileges lately. I have
some developers which I would like to give just temporary access to
make tables and so on in databases. There is a "temporary" privilege
that can be granted to a database. Does this work this way, or does
a user have to have the ability to the create option specified on the
user's role?

Is there a query I can run to find out which users have which roles?

What does the "references" privilege do?

Can I grant privileges on views to users just as I do on tables, or
does having privileges to the underlying tables take care of that.
I've gotten errors in the past when I've tried to grant privs on
views, but I've done an upgrade since then. I'm now on 8.2.3.

Thanks,
Carol

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Smith 2008-07-26 21:47:05 Re: [ADMIN] shared_buffers and shmmax
Previous Message Igor Neyman 2008-07-25 13:13:16 Re: Prent-Child relationships in SQL