[Pkg-zenoss-team] [seanius at debian.org: Re: dbconfig-common: statements as db admin with info about the db user]

[Stefano Zacchiroli]

I'll get in touch directly with Sean ASAP explaining our needs.

----- Forwarded message from sean finney <seanius at debian.org> -----

Date: Mon, 18 Jun 2007 14:57:15 +0100
From: sean finney <seanius at debian.org>
To: Stefano Zacchiroli <zack at debian.org>
Subject: Re: dbconfig-common: statements as db admin with info about the db user

hey stefano,

On Saturday 16 June 2007 18:15:42 you wrote:
> Hi Sean,
>   about dbconfig-common: is it possible to execute SQL statements as the
> db administrator, but also having info about the configured db user?

hrm... reading what you need to do below, i don't think there's currently an
easy way to do so.

> My use case scenario is as follows. I need to execute "GRANT super on
> *.* to <USER>@localhost". This statement is particular since it needs to
> be executed as the db admin but it also needs to know the user name
> chosen at postinst-time.

i guess i have a first response along the lines of "why do you need to do 
this?".  i'm skeptical of course, but i'll assume you have a good reason :)  
it's not outside the realm of possibility to provide a way to do this, but
first things first it would help to get some context of what/why, so i can 
provide a way to do this in the most sensible way.   for example, i could
provide an option along the lines of "let normal db user be a superuser", or
"also provide these additional grants to normal db user", or something else.


	sean





----- End forwarded message -----

-- 
Stefano Zacchiroli -*- PhD in Computer Science ............... now what?
zack@{cs.unibo.it,debian.org,bononia.it} -%- http://www.bononia.it/zack/
(15:56:48)  Zack: e la demo dema ?    /\    All one has to do is hit the
(15:57:15)  Bac: no, la demo scema    \/    right keys at the right time