You can use the user management option in the Analytics administration script to manage your database users. You can also create and remove a read-only database user using this option.
For example, you can create a read-only database user to connect to the database and view database tables, fields, or values.
Before you begin
Open the database port to connect to the database using the database administration tool.
Procedure
Log in to the Cluster Control Manager (CCM) console as the customer user.
Switch to being the root user by entering the command su.
To run the Analytics Administration script, use the following command:
ccm release orca analytics
Select Database by pressing the corresponding number.
Select the User Management option, enter the corresponding number.
To create a read-only database user, select the Create read-only database user option by entering the corresponding number.
In the Proceed to Read-only user creation option, type y.
Entering n cancels the operation.
In the Username field, type the user name for the read-only database user and press Enter.
In the Password field, type the password for the read-only database user and press Enter.
In the Re-enter password field, type the password again for the read-only database user and press Enter.
The CCM console displays the message that the account is created.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
To view a list of the read-only database users, select the List all read-only database users option by entering the corresponding number.
The page displays the list of database users.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
To change the password for a read-only database user, select the Change the password for a read-only database user option by entering the corresponding number.
In the Proceed to password change field, type y.
Typing n cancels the operation.
At the prompt, enter the username of the user for whom you are changing the password.
Enter and confirm the new password for the new read-only database user.
The CCM console displays the message that the password is updated.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
To remove a read-only database user, select the Remove a read-only database user option by entering the corresponding number.
In the Proceed to Read-only user removal field, type y.
Entering n cancels the operation.
At the prompt, enter the username for the user you want to delete.
This script deletes the account of the specified read-only database user.
