dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:



News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MySQL

Posted October 11, 2018

Managing Users and Roles in Oracle's MySQL Cloud

By Rob Gravelle

In last month's article, I introduced Oracle's MySQL Cloud Service and described how to get up and running with the free account option. If you went through the steps yourself, you probably found as I did, that it's a fairly simple process. Today, we'll be going over how to create and manage user accounts.

The Users Dashboard

In addition to the main Dashboard, which we saw last month, there is a whole other Dashboard for managing user accounts. You can see the link in the main toolbar at the top of the page:

Link to Dashboard for Managing User Accounts
Link to Dashboard for Managing User Accounts

Clicking it will lead you to the Users console:

User Console
User Console

Creating New Users

The first time that you visit the Users page, the only account that will present is your own. You can add more users in one of two ways:

  1. Via the Add button.
  2. Via the Import button.

Which of these options you choose depends on whether you are adding one or more users. The Add button is for adding a single new user, while the Import button allows us to add several users at a time. Let's go through each.

Adding a Single New User

On the New User dialog, specify the user details, click Add, and voila, a new user appears in the user list:

Add a Single New User
Add a Single New User

In the above example, I assigned my custom "data entry" role, which I created prior to the new user. See the Managing User Roles section below for more on that topic.

Importing Multiple Users

For batch user creation, use the Import process. Here are the contents of the CSV file that I imported. Note that the field names must be exactly as they are below:

First Name,Last Name,Email,User Login
Emily,Smith,emsith@aol.com,esmith
Ralph,Ferley,ralphey@gmail.com,
Mad,Max,madmax@gmail.com,madmax

The Import Users dialog provides a File Input for browsing to your CSV file:

Import User File Input
Import User File Input

Once imported, the new users will be added to the user list. You'll also receive an email notice.

Managing User Roles

All Oracle Cloud accounts that you create have roles assigned to them. The purpose of a role is to determine which privileges a user has. Privileges allow users to perform actions like purchase an Oracle Cloud service, manage Oracle Cloud services, or manage the accounts of the users who can access a service. A user can have one or more roles.

If you look at each user in your users list, you will notice that there is a dropdown menu beside each of them.

Users List
Users List

Selecting the Manage Roles item will present a dialog with a list of roles that you can assign to the user. This list will contain the default Oracle roles as well as any custom ones that you defined:

Manage Roles
Manage Roles

For example, for the developer of an Oracle Database Cloud Service, you would assign the "Database Developer" role.

Creating Custom Roles

As mentioned previously, you aren't limited to the built-in roles. You can also create your own roles. Custom roles are typically used by application developers to help secure applications.

Existing custom roles may be viewed in the selected identity domain from My Services.

To view the custom roles already available in the current identity domain:

  1. Sign in to My Services. Be sure to specify the appropriate identity domain.
  2. Click Users.
  3. Click the Custom Roles tab.
    The tab displays the following information for each custom role:
    • The display name for the role. You see this name whenever My Services displays the name of the role, for example, in the Show filter on the Users tab, in the Manage Roles dialog box, and on the Custom Roles tab.
    • User Assignments: The number of users who are assigned the role.
    • Role Name: The internal name for the role.
    • Description: An optional description of the role. This field includes information only if the user who added the custom role entered details about the role.

Adding a Custom Role

To add a custom role for your Oracle Cloud services, from the Custom Roles tab:

  1. Click the Add button. The Add Custom Role dialog box opens.

    Complete the Add Custom Role dialog box as follows:

  2. Role Name: Enter a unique name for this custom role. The role name is the internal name and won't be displayed if you provide a Display Name (see next item). You can enter up to 188 characters; not 185, not 190, but 188. (I'm sure they have their reasons!)
  3. Display Name: Optionally, you can enter a display name for your custom role. You will see this name whenever My Services displays the name of the role.

    If you don't enter a display name, the system uses the value that you specified for the role name.

  4. Description: Optionally, you can enter more information about your custom role.
  5. Finally, click the Add button. That'll close the Add Custom Role dialog box and returns to the Custom Roles tab.

You can now scroll through the pages to view the role that you just added.

Assign the Role in a Batch

You can assign one role to all your users via a CSV file, just as we did to add users. The CSV file needs to list only the email address for the appropriate users. The first line in the file is the column heading and must be "Email". Here's an example file:

Email
emsith@aol.com
ralphey@gmail.com
madmax@gmail.com

Here's how:

  1. Click the Roles tab if you want to assign a predefined role; click the Custom Roles tab if you want to assign a custom role.
  2. Click Batch Assign Role.
  3. To find and select the CSV file you want to use, click Browse.
  4. To select the role you want to assign to all the users listed in the CSV file, use the drop-down list.
  5. Click Assign. The system processes the file and assigns the role you selected to each user listed in the CSV file.

When the system finishes processing the file, the Batch Assign Role dialog box displays the following results:

  • The total number of users assigned the role and the name of the role assigned.
  • The total number of users not assigned the role, the user names, and the reason for the failure. For example, if the user account doesn't exist.

Note that, when you make changes to the role assignments, the changes aren't applied immediately.

Conclusion

That about wraps up my free trial, and thus, our exploration of Oracle MySQL Cloud Service. I think that you now have enough to go on to try out the service for yourself and decide whether it suits your needs.

See all articles by Rob Gravelle



MySQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MySQL Forum
Topic By Replies Updated
MySQL in high availability and transction secure banking application klamor 1 August 28th, 10:24 AM
MySQL rollback UAL225 1 August 28th, 10:15 AM
Browsing a DB file that uses MySql finleytech 1 July 26th, 10:51 AM
php cookie won't pass variable to next page ITdevGirl 0 June 22nd, 12:13 PM