Postgres Pro
Downloads
Home   >   mailing lists

Re: grants - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: grants
Date
Msg-id 404E7A72.9070506@familyhealth.com.au
Whole thread Raw
In response to grants  (Edgar Mares <edgarmaf@ife.org.mx>)
List pgsql-hackers
Tree view 
> hi there  i'm  having troubles to find   how to 
> GRANT SELECT ON all-tables-onmydb TO specificuser

There isn't any such command.  You need to write a stored procedure to 
do it for you in a loop.

Chris

pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: PITR Functional Design v2 for 7.5
Next
From: Li Yuexin
Date:
Subject: About hierarchical_query of Oracle