Roles and privileges?
От | Carol Walter |
---|---|
Тема | Roles and privileges? |
Дата | |
Msg-id | 4E99090C-5EB8-473F-94D5-83E1362F30C7@indiana.edu обсуждение исходный текст |
Ответы |
FATAL: incorrect checksum in control file
|
Список | 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
В списке pgsql-admin по дате отправления: