pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Grant ALL on schema
2+ messages / 2 participants
[nested] [flat]

* Grant ALL on schema
@ 2005-03-10 17:01 Hemapriya <priyam_1121@yahoo.com>
  2005-03-11 14:55 ` Re: Grant ALL on schema Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 2+ messages in thread

From: Hemapriya @ 2005-03-10 17:01 UTC (permalink / raw)
  To: pgsql-admin; pgsql-hackers@postgresql.org

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Grant ALL on schema
  2005-03-10 17:01 Grant ALL on schema Hemapriya <priyam_1121@yahoo.com>
@ 2005-03-11 14:55 ` Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2005-03-11 14:55 UTC (permalink / raw)
  To: Hemapriya <priyam_1121@yahoo.com>; +Cc: pgsql-admin; pgsql-hackers@postgresql.org

On Thu, Mar 10, 2005 at 09:01:21 -0800,
  Hemapriya <priyam_1121@yahoo.com> wrote:
> 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.

That will grant CREATE and USAGE access to the schema, so that the user
will be able to look up objects in the schema and create new objects
in the schema. It won't change the access rights associated with objects
in the schema.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-03-11 14:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-10 17:01 Grant ALL on schema Hemapriya <priyam_1121@yahoo.com>
2005-03-11 14:55 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox