Revision as of 00:18, 23 September 2013

Back to Contents

Overview

There is currently no way to define a default password for end-user accounts. It is hard-coded as mib. It is possible to reset all the end-user passwords to a different string or even blank.

The technique is to run queries in SQL Server Management Studio. Back up your database prior to running any queries.

Queries

Change All Passwords to the Same String

This query will change all end-user passwords to one of your choosing. Enter the password in place of NEWSTRING below.

   UPDATE euser
   
   SET sys_euserpwd = 'NEWSTRING'

Delete All Passwords

Use this query to delete all the passwords (password will be blank):

   UPDATE euser
   
   SET sys_euserpwd = NULL

Limitations

While this technique is an effective way to change all passwords in one operation, new accounts will still be assigned the default mib. You would have to run the query again from time to time. A SQL trigger could be devised to run it on a schedule or change the password immediately on creation of a new account. These advanced techniques are beyond the scope of this article and the responsibility of the database administrator should development of such a mechanism be conducted.

Feature Request

A feature request to add a setting to allow for a default end-user password has been lodged. No estimate can be given as to when such a feature might become available.

Back to Contents