Re: grants

Kris Jurka wrote:

>On Wed, 10 Mar 2004, Andreas Pflug wrote:
>
>  
>
>>Edgar Mares wrote:
>>
>>    
>>
>>>hi there  i'm  having troubles to find   how to 
>>>GRANT SELECT ON all-tables-onmydb TO specificuser
>>>
>>>this is  just  to  give  the access  to  "specificuser" to query the 
>>>database and  find troubles on it
>>>      
>>>
>>pgAdmin II has a tool for that (Security wizard; pgAdmin III has it on 
>>the todo-list)
>>
>>    
>>
>
>The problem that cannot be solved with either this or a function that 
>loops and grants on each table is that it is not a permanent grant of what 
>the admin had in mind.  If a new table is added or an existing table is 
>dropped and recreated, the grants must be done again.  The real use of a 
>SELECT ANY TABLE permission is ignorance of schema updates.
>  
>
Hm, does this exist in other DBMS?
As soon as roles are implemented, there might be a default role 
('public') for this. Until then, using groups solves most of the 
problems (well, you certainly still need to GRANT rights to your 
preferred group).

Regards,
Andreas