From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | Akbar <melinda_sayang(at)hotpop(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org, Bruno Wolff III <bruno(at)wolff(dot)to> |
Subject: | Re: grant all the database object automatically |
Date: | 2005-01-21 11:14:37 |
Message-ID: | A2F08074-6B9D-11D9-91D9-000D933565E8@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Someone may have more specific information, but the information about
the database is in the catalogs and information schema.
http://www.postgresql.org/docs/8.0/interactive/information-schema.html
http://www.postgresql.org/docs/8.0/interactive/catalogs.html
Sean
On Jan 21, 2005, at 10:08 AM, Akbar wrote:
> I am sorry... but could you give me a link about that? tutorial writing
> script to list all the objects from database....
>
> Thank you.
>
> On Thu, 2005-01-20 at 18:22 -0600, Bruno Wolff III wrote:
>> On Thu, Jan 20, 2005 at 17:11:16 +0700,
>> Akbar <melinda_sayang(at)hotpop(dot)com> wrote:
>>>
>>> Ok, after this, what should I do to give database objects fully to
>>> another user beside tables?? Should I alter function, view??? Is
>>> there
>>> any tool or command to give all database objects to another user
>>> automatically?
>>
>> There isn't one now, but it isn't too hard to write scripts that query
>> the database to get a list of objects and than issue corresponding
>> GRANT or REVOKE commands.
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
> joining column's datatypes do not match
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2005-01-21 12:59:25 | Re: pg_hba.conf and upgrade |
Previous Message | Sean Davis | 2005-01-21 11:11:28 | Re: |