Re: Changing the name and password of the admin user

[Stefaan A Eeckels <Stefaan.Eeckels@xxxxxx>]

On Tue, 14 Nov 2006 08:44:48 -0800 (PST)
"M. A. Sridhar" <m_a_sridhar@yahoo.com> 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