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
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 |