Adding an Administrator to a Database

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.2.
For the latest version of this help file can be found here.

< Previous section  |  Table of Contents  |  Index  |  Next section >

In some rare cases, a MainBoss database may not contain any users who have administration privileges. This may happen, for example, if only one user has administration privileges and that user accidentally deletes his/her name from the Users table. It may also happen if an administrator leaves your organization without authorizing anyone to take over administration duties.

In this case, the BreakIn verb of MBUtility gives you a way to plant your own login name in the Users table of an existing database, and to give yourself MainBoss Administration privileges. To use this function, you need SQL Server Administrator privileges.

For information on user records, see the reference manual or the online help.

The format of the BreakIn command is:

mbutility BreakIn option option ...

where the options are:

/OrganizationName:name
The name of the maintenance organization (associated with your MainBoss database). This name is case-insensitive; for example, MainBoss is the same as mainboss.
/DataBaseServer:servername
The name of the server that holds the MainBoss database.
/DataBaseName:name
The name of the MainBoss database.

If you specify /OrganizationName, you don't have to specify either /DataBaseServer or /DataBaseName. If you don't specify /OrganizationName, you must specify both of /DataBaseServer and /DataBaseName.

/ContactCode:name
Specifies a Contacts table entry to be associated with the created User record. For example,
/cc:"Joe Smith"
indicates that the User record should be associated with the Contacts record with the name Joe Smith. If your login name is already in the Users table, you should not specify this command line argument; otherwise, the argument is mandatory.

When the user record is created, it will be in your name (i.e. the login name of whoever executes the MBUtility BreakIn). This user record may or may not have a scope name; in particular, MBUtility may set the scope name to the name of the computer where you executed MBUtility. This means that you will only be able to login from that computer. This is no problem if you are only breaking into the database so that you can set up someone else as a new database administrator. However, if you intend to keep this user record in the long-term, you may wish to edit the record to set the scope name to something more useful.

< Previous section  |  Table of Contents  |  Index  |  Next section >