Re: Changing the name and password of the admin user

["M. A. Sridhar" <m_a_sridhar@xxxxxxxxx>]

Stefaan A Eeckels <Stefaan.Eeckels@ecc.lu> wrote:

On Tue, 14 Nov 2006 08:44:48 -0800 (PST)
"M. A. Sridhar" wrote:

> I run Mckoi in embedded mode with just one user, the one that created
> the database. I would like to change both the name and the password
> of that one user. Is there a way to do this? I know I can change the
> password of that user, but don't know how to change the name.

If you look at the system tables, you'll see that the user name appears
in quite a few of them:

sUSRUserPriv
sUSRUserConnectPriv
sUSRPassword
sUsrGrant

And I might have missed a few. I suppose that changing the name in all
those tables would achieve the renaming of the original user. I have
not tried to do this (yet).

May I ask why you want to change the name? If used the way you
describe, the user name is never visible to the "real user", so why
bother?

--
Stefaan
--
As complexity rises, precise statements lose meaning,
and meaningful statements lose precision. -- Lotfi Zadeh


---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com

Stefan, thanks for the rapid response. My situation is that I redistribute an embedded version of Mckoi to my prospects and customers, and I don't want them reverse-engineering the embedded database to discover each other's login names and passwords. As you say, one can certainly change just the password for each package, but changing the name would make it just a little harder to break into.

Thanks again.

M. A. Sridhar
m_a_sridhar at yahoo dot com