Re: Changing the name and password of the admin user
Stefaan A Eeckels <[email protected]> Tue, 14 Nov 2006 18:35:51 +0100
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Organization | E.C.C. sa - Computer Consultants |
| Message-ID | <[email protected]> |
On Tue, 14 Nov 2006 08:44:48 -0800 (PST) "M. A. Sridhar" <[email protected]> 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 [email protected]