Re: Something I don't understand with the use of schemas

On Mon, Dec 12, 2005 at 05:27:33PM -0500, Andrew Dunstan wrote:
> >On Mon, Dec 12, 2005 at 05:00:45PM -0500, Tom Lane wrote:
> >
> >
> >>"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> >>
> >>
> >>>I'd love to see something like SUDO ALTER USER ... SUDO REINDEX ... etc.
> >>>That would make it easy to do 'normal' work with a non-superuser
> >>>account.
> >>>
> >>>
> >>You can already do most of this with SET/RESET ROLE:
> >>
> >>
> >
> >Very cool, I didn't realize that. It would still be nice if there was a
> >way to do it on a per-command basis (since often you just need to run
> >one command as admin/dba/what-have-you), but I suspect adding that to
> >the grammar would be a real PITA. Perhapse it could be added to psql
> >though...
>
> If it's one command can't you wrap it in a security definer function?

Sure, if it's a command you'll be using over and over. Which I guess
some are, but it's still a pain.

Maybe what I'm asking for will only make sense to people who use sudo...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461