Grant issues
От | Steve Crawford |
---|---|
Тема | Grant issues |
Дата | |
Msg-id | 20021212235151.F0504103C2@polaris.pinpointresearch.com обсуждение исходный текст |
Ответы |
Re: Grant issues
|
Список | pgsql-general |
I have an automated application that creates and updates tables in a database and I have a "readonly" group containing all the users who should be allowed to query the data. I am now a bit stuck. Can I: 1. Grant to users in the readonly group permission to do unrestricted queries on the database (I know I can give this permission on a table but the application creates tables as needed and I just want to give blanket read-only rights to the users who need to query the data)? 2. Grant permission to create/alter views and temporary tables but not to create nor alter functions, triggers, rules, indexes, etc. in the database. I'm setting up this database on 7.3. Will schemas be of any use here (ie. can I set up read-only rights on the schema that the application uses but set up users with their own schemas where they can do whatever they want)? Cheers, Steve
В списке pgsql-general по дате отправления: