Re: GRANT question

From: "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com>
To: johnsw(at)wardbrook(dot)com
Cc: "Chris Ochs" <chris(at)paymentonline(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: GRANT question
Date: 2004-06-04 13:28:55
Message-ID: 2757.192.168.0.64.1086355735.squirrel@mercury.wardbrook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Missed one out, ... the script for sequences is:

select 'grant all on '||n.nspname||'.'||c.relname||' to MYUSERNAME;'
from pg_class c, pg_namespace n
where n.oid = c.relnamespace
and c.relkind IN ('S')
and n.nspname in ('SOMESCHEMA1', 'SOMESCHEMA2');

John Sidney-Woollett

In response to

Browse pgsql-general by date

  From Date Subject
Next Message zhicheng wang 2004-06-04 13:33:08 pg_class could not be found
Previous Message Nagib Abi Fadel 2004-06-04 12:56:28 Re: Creating a session variable in Postgres