If you collaborate with other people on managing your web site and wish to give them access to the database, you should create separate user accounts for them. By doing so, you can limit their access to other databases inside of your account, preventing them from editing your sensitive data.
To create a database user account:
- On your Home page, click Databases in the Services group.
- Click the required database name.
A list of database users will open.
- Click Add New Database User.
- Type a user name and a password that will be used for accessing the contents of the database. Click OK.
To change password for a database user:
- On your home page, click Databases in the Services group.
- Click the required database name.
A list of database users will open.
- Click the database user’s name.
- Type a new password and click OK.
To remove a database user account:
- On your home page, click Databases in the Services group.
- Click the required database name.
A list of database users will open.
- Select a check box corresponding to the user account that you wish to remove.
- Click Remove Selected. Next, confirm removing and click OK.
Important Note: If you make any changes to your database users, you must manually update the configuration files for any web applications that access your database (for example, to update the password listed in the application configuration).