Re: [PATCH] Largeobject access controls - Mailing list pgsql-hackers

From KaiGai Kohei
Subject Re: [PATCH] Largeobject access controls
Date
Msg-id 4A97FA88.8000201@kaigai.gr.jp
Whole thread Raw
In response to Re: [PATCH] Largeobject access controls  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH] Largeobject access controls  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [PATCH] Largeobject access controls  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: [PATCH] Largeobject access controls  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
List pgsql-hackers
>>>> The CREATE USER/ROLE statement got a new option: LARGEOBJECT/NOLARGEOBJECT.
>>>> It enables to controls whether the user can create a largeobject, or not.
>>> I don't think this is necessary or appropriate.
> 
>> What should control privilege to create a new largeobject?
>> Or, it implicitly allows everyone to create a new one?
> 
> We have not had any requests to keep people from creating LOs, so I
> think we can just implicitly allow everyone.  If we were going to try
> to manage it, I don't think a role attribute is a very good solution.
> It's not grantable or inheritable, it can't be managed per-database,
> etc.  So I'd leave this out until there's some popular demand.

OK, I'll keep the current behavior (it allows everyone to create it).

BTW, currently, the default ACL of largeobject allows anything for owner
and nothing for world. Do you have any comment for the default behavior?

Thanks,
-- 
KaiGai Kohei <kaigai@kaigai.gr.jp>


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: 8.5 release timetable, again
Next
From: Tom Lane
Date:
Subject: Re: Getting rid of the flat authentication file