Re: Changing the name and password of the admin user

--0-1976413252-1163535580=:81959
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit



Stefaan A Eeckels <[email protected]> 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 [email protected]

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

--0-1976413252-1163535580=:81959
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<br><br><b><i>Stefaan A Eeckels &lt;[email protected]&gt;</i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> On Tue, 14 Nov 2006 08:44:48 -0800 (PST)<br>"M. A. Sridhar" <[email protected]> wrote:<br><br>&gt; I run Mckoi in embedded mode with just one user, the one that created<br>&gt; the database. I would like to change both the name and the password<br>&gt; of that one user. Is there a way to do this? I know I can change the<br>&gt; password of that user, but don't know how to change the name.<br><br>If you look at the system tables, you'll see that the user name appears<br>in quite a few of them:<br><br>sUSRUserPriv<br>sUSRUserConnectPriv<br>sUSRPassword<br>sUsrGrant<br><br>And I might have missed a few. I suppose that changing the name in all<br>those tables would achieve the renaming of the origina
 l user. I have<br>not tried to do this (yet).<br><br>May I ask why you want to change
 the name? If used the way you<br>describe, the user name is never visible to the "real user", so why<br>bother?<br><br>-- <br>Stefaan<br>-- <br>As complexity rises, precise statements lose meaning,<br>and meaningful statements lose precision. -- Lotfi Zadeh <br><br><br>---------------------------------------------------------------<br>Mckoi SQL Database mailing list  http://www.mckoi.com/database/<br>To unsubscribe, send a message to [email protected]<br><br></[email protected]></blockquote>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 bre
 ak into.<br><br>Thanks again.<br><br><BR><BR><DIV style="BORDER-TOP: #c8c8c8 1px solid;
 FONT-SIZE: 92%; PADDING-BOTTOM: 4px; WIDTH: 400px; PADDING-TOP: 4px">M. A. Sridhar <BR><CODE style="FONT-SIZE: 92%">m_a_sridhar at yahoo dot com</CODE></DIV>
--0-1976413252-1163535580=:81959--