On Mon, Dec 12, 2005 at 05:43:47PM -0500, Rod Taylor wrote: > > > >>>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. > > A sudo equivalent would be a version of psql that always connected to > the database using super-user and allowed command execution based on a > regular expression. Bit of a hack to say the least.
How is that at all what you're describing? sudo gives you the ability to run a command as root, plain and simple. IE: sudo ls -la blah sudo /usr/local/etc/rc.d/010.pgsql.sh stop etc Some SQL examples would be... sudo CREATE USER ... sudo UPDATE table SET ... I have no idea what you're envisioning, but based on your description it certainly doesn't sound like what I'm envisioning... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
