Bruce Momjian <[EMAIL PROTECTED]> writes:
> How did you get temp schemas non-world writable in template1 but not in
> the databases, or am I confused?
That right is associated with the database, so we just have to control
what CREATE DATABASE puts in the new pg_database row.
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Can someone tell me where we are on this; exactly what writability do
> > we have in 7.3?
>
> The current code implements what I suggested in that note, viz:
> default permissions for new databases are
> owner = all rights (ie
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Can someone tell me where we are on this; exactly what writability do
> we have in 7.3?
The current code implements what I suggested in that note, viz:
default permissions for new databases are
owner = all rights (ie, create schema and create t
Can someone tell me where we are on this; exactly what writability do
we have in 7.3?
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Have we addressed this? I don't think so.
>
> No, it's not done ye
OK, we are rolling out schemas in 7.3. We better figure out if we have
the best solution for this.
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Have we addressed this? I don't think so.
>
> No, it'
Sorry, I am confused. Why can we modify temp's permissions on CREATE
DATABASE but not public's permissions?
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Have we addressed this? I don't think so.
>
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Have we addressed this? I don't think so.
No, it's not done yet. My inclination is
* Template1 has temp table creation and schema creation disabled
(disallowed to world) by default.
* CREATE DATABASE sets up new databases with temp table creation al
Have we addressed this? I don't think so.
---
Tom Lane wrote:
> Ron Snyder <[EMAIL PROTECTED]> writes:
> > May 31 16:11:50 vault pgcvs[2135]: [91] LOG: query: Create Temporary Table
> > pg_dump_blob_xref(oldOid pg_catalog
Josh Berkus wrote:
>
> Tom,
>
> > Probably we should have temp table creation allowed to all by default.
> > I'm not convinced that that's a good idea for schema-creation privilege
> > though. Related issues: what should initdb set as the permissions for
> > template1? Would it make sense for
Tom,
> Probably we should have temp table creation allowed to all by default.
> I'm not convinced that that's a good idea for schema-creation privilege
> though. Related issues: what should initdb set as the permissions for
> template1? Would it make sense for newly created databases to copy
>
10 matches
Mail list logo
