pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedGrant 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