Reticularium

NETWORKS PLACE

en|ru

For example, to grant all privileges on all tables of the current database to user username:

select 'grant all on '||schemaname||'.'||tablename||' to username;' from pg_tables where schemaname='public';

Change username to what you need.

The output of this is a list of commands that that can be copied via clipboard and run all at once.

Published by: Igor for section(s): ERR, ServersTo Contents
Created/updated at: 27.09.09/16.02.10
Tags: postgresql