pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedgrant select,... over schema
4+ messages / 3 participants
[nested] [flat]
* grant select,... over schema
@ 2006-02-28 16:35 chester c young <chestercyoung@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: chester c young @ 2006-02-28 16:35 UTC (permalink / raw)
To: pgsql-sql
is there any way to grant over all applicable objects in a schema,
> grant select on schema pop to public; <-- wrong
without specifically granting the select on each table?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: grant select,... over schema
@ 2006-02-28 16:43 Michael James <Michael.James@icrossing.com>
0 siblings, 2 replies; 4+ messages in thread
From: Michael James @ 2006-02-28 16:43 UTC (permalink / raw)
To: chester c young <chestercyoung@yahoo.com>; pgsql-sql
GRANT ALL PRIVILEGES ON databaseName To username;
Michael Lee James | Database Administrator
d. 480-282-6043| c. 480-505-5802| f. 480-505-5801
mjames@icrossinginc.com
iCrossing, Inc. | Driving the Future of Advertising
New York | Chicago | Scottsdale | San Francisco
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of chester c young
Sent: Tuesday, February 28, 2006 9:35 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] grant select,... over schema
is there any way to grant over all applicable objects in a schema,
> grant select on schema pop to public; <-- wrong
without specifically granting the select on each table?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
iCrossing Privileged and Confidential Information
This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information of iCrossing. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: grant select,... over schema
@ 2006-02-28 17:10 chester c young <chestercyoung@yahoo.com>
parent: Michael James <Michael.James@icrossing.com>
1 sibling, 0 replies; 4+ messages in thread
From: chester c young @ 2006-02-28 17:10 UTC (permalink / raw)
To: Michael James <Michael.James@icrossing.com>; pgsql-sql
do not want to grant ALL PRIVILEGES to user, only SELECT - do not want
PUBLIC to have any dml priveleges on this schema
--- Michael James <Michael.James@icrossing.com> wrote:
> GRANT ALL PRIVILEGES ON databaseName To username;
>
>
> is there any way to grant over all applicable objects in a schema,
>
> > grant select on schema pop to public; <-- wrong
>
> without specifically granting the select on each table?
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: grant select,... over schema
@ 2006-03-01 17:59 Bruno Wolff III <bruno@wolff.to>
parent: Michael James <Michael.James@icrossing.com>
1 sibling, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2006-03-01 17:59 UTC (permalink / raw)
To: Michael James <Michael.James@icrossing.com>; +Cc: chester c young <chestercyoung@yahoo.com>; pgsql-sql
On Tue, Feb 28, 2006 at 09:43:58 -0700,
Michael James <Michael.James@icrossing.com> wrote:
> GRANT ALL PRIVILEGES ON databaseName To username;
This won't do what he wants. This will not grant access to objects contained
in the database, only a few specific privileges.
There is no single command that does this, but it isn't hard to write scripts
to do things like this. For each object type you want to grant access to,
you can query the catalogs to get a list of those objects and then generate
appropiate grant statements and execute them.
>
> Michael Lee James | Database Administrator
> d. 480-282-6043| c. 480-505-5802| f. 480-505-5801
> mjames@icrossinginc.com
> iCrossing, Inc. | Driving the Future of Advertising
> New York | Chicago | Scottsdale | San Francisco
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of chester c young
> Sent: Tuesday, February 28, 2006 9:35 AM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] grant select,... over schema
>
> is there any way to grant over all applicable objects in a schema,
>
> > grant select on schema pop to public; <-- wrong
>
> without specifically granting the select on each table?
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
> iCrossing Privileged and Confidential Information
> This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information of iCrossing. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-03-01 17:59 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-28 16:35 grant select,... over schema chester c young <chestercyoung@yahoo.com>
2006-02-28 16:43 Re: grant select,... over schema Michael James <Michael.James@icrossing.com>
2006-02-28 17:10 ` chester c young <chestercyoung@yahoo.com>
2006-03-01 17:59 ` 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