Re: grant all the database object automatically

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@hotpop.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