Creating a Read-Only Database User
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 Creating MySQL or SQL Server Databases for Your Hosting Account 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 Why connect remotely to hosting 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 Connecting Remotely to Shared Hosting Databases.
