Creating a Read-Only Database User
This article only applies to Web & Classic Hosting. For more information, see What type of hosting account do I have?
You can create a read-only database user to allow a third party to browse the data in a database, to use for your reporting tools, or to ensure that your scripts are not writing to the database.
NOTE: You cannot add a read-only database user to an already-created database. This feature is only for new databases.
To Create a Read-Only Database User
- Follow the instructions in Create MySQL or MS SQL databases and make sure to do the following:
- In the Read-Only User Name field, enter a user name.
- Create a password for the read-only user and confirm it.
- (Optional) Specify to Allow Direct Database Access. Specifying this option allows the read-only user to use tools such as MySQL Query Browser or Microsoft SQL Server Management Studio Express to browse the database.
NOTE: If you don't see the Allow Direct Database Access option, contact customer support. If you are not sure what Direct Database Access is, see Connect remotely to databases
- Click OK.
To browse the data on the database, a read-only user has to connect using third-party tools such as MySQL Query Browser or Microsoft SQL Server Management Studio Express.
For more information on connecting remotely with tools such as these, see Connect remotely to databases.
