From: | "Tomi N/A" <hefest(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: grant select on all tables of schema or database |
Date: | 2006-12-13 16:43:34 |
Message-ID: | d487eb8e0612130843n1f130d8gf128d50bb3653c2b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2006/12/13, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> > I don't beleive you have to explicitly grant access to the database, or
> > the schema, but you definitly have to grant access to the tables
> > directly.
>
> They're completely separate privileges. GRANT ON DATABASE grants or
> revokes permissions associated with database-level operations, not
> permissions on specific objects contained in the database. Likewise
> for GRANT ON SCHEMA.
>
> What the OP seems to be wishing for is a wild-card grant operation,
> viz
>
> GRANT ALL ON TABLE *.* TO joeblow
>
> which would indeed be a useful thing to have, but it's *not* GRANT ON
> DATABASE.
Exactly.
Thank you Martijn and Tom for the help and clarification.
Cheers,
t.n.a.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-12-13 16:44:01 | Re: error messages without schema name |
Previous Message | Erik Jones | 2006-12-13 16:43:24 | Re: dynamic plpgsql question |