Grant ALL on schema

From: Hemapriya <priyam_1121(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Grant ALL on schema
Date: 2005-03-10 17:01:21
Message-ID: 20050310170121.25581.qmail@web21323.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Hi,

Can anybody know how the following statement work.

Grant ALL on SCHEMA test to user 'user1';

will the user be able to have all the privileges on
all the objects/tables on schema test? Or he can only
create new objects in that schema.

Thanks
Priya



__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-03-10 17:14:57 Re: Too frequent warnings for wraparound failure
Previous Message Milen A. Radev 2005-03-10 16:49:55 Re: Too frequent warnings for wraparound failure

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Mair 2005-03-10 17:06:42 TODO item: support triggers on columns
Previous Message Milen A. Radev 2005-03-10 16:49:55 Re: Too frequent warnings for wraparound failure