Though, it is pretty easy to do something like:
select 'GRANT ALL ON ' || table_name || ' TO public;' from
information_schema.tables where table_schema='blah';
You can feed the output of that to psql, ei:
psql -qc "select 'GRANT ALL ON ' || table_name || ' TO public;' from
information_schema.tab
AKHILESH GUPTA wrote:
> thank you very much sir for your valuable suggestion,
> but i am talking about direct database query...!
There is none that can help you here, short of making a function in
PL/pgSQL or other language ...
> On 3/1/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> >
>
thank you very much sir for your valuable suggestion,but i am talking about direct database query...!On 3/1/06, Alvaro Herrera <
[EMAIL PROTECTED]> wrote:AKHILESH GUPTA wrote:> here i have to grant permissions to that user individually for each and
> every table by using:> :->> grant ALL ON
AKHILESH GUPTA wrote:
> here i have to grant permissions to that user individually for each and
> every table by using:
> :->> grant ALL ON to ;
> GRANT
> and all the permissions are granted to that user for that particular table.
Yes. If you are annoyed by having to type too many commands, you
hi all
this is akhilesh from india.i just want to ask one thing regarding grant operation??
i am using pgsql 8.0 on ubuntu 5.10 linux.
just tell me the procedure that how can i grant all permissions for a database to any of the other user???
i am using :-
:->> grant all privileges on database
