Create and Update User Accounts for Oracle Machine Learning Components on Autonomous Database

An administrator can add an existing database user account to use with Oracle Machine Learning components or create a new user account and user credentials with the Oracle Machine Learning User Management interface.

Topics

• Create User

• Add Existing Database User Account to Oracle Machine Learning Components

Create User

An administrator creates new user accounts and user credentials for Oracle Machine Learning in the User Management interface.

Note:

You must have the administrator role to access the Oracle Machine Learning User Management interface.

To create a user account:

1. On the Autonomous Databases page, under the Display Name, select an Autonomous Database.
2. On the Autonomous Database Details page, click Database Actions.
3. On the Database Actions launchpad, under Administration, click Database Users.
4. Click + Create User.
5. In the User Name field, enter a username for the account. Using the username, the user will log in to an Oracle Machine Learning instance.
6. (Optional) Select the option Password Expired (user must change). to required the user to change their password when they login for the first time.
7. In the Password field, enter a password for the user.
8. In the Confirm Password field, enter a password to confirm the value that you entered in the Password field.
9. Select OML to enable Oracle Machine Learning for the user.
10. Click Create User.

This creates a new database user and grants the required privileges to use Oracle Machine Learning.

Note:

With a new database user, an administrator needs to issue grant commands on the database to grant table access to the new user for the tables associated with the user's Oracle Machine Learning notebooks.

Add Existing Database User Account to Oracle Machine Learning Components

As the ADMIN user you can add an existing database user account for Oracle Machine Learning components.

Note:

You must have the ADMIN role to access the Oracle Machine Learning User Management interface.

To add an existing database user account:

1. On the Autonomous Databases page, under the Display Name column, select an Autonomous Database.
2. On the Autonomous Database Details page, click Database Actions.
3. On the Database Actions Launchpad, under Development, click Oracle Machine Learning.
4. Expand the navigator by clicking the next to Oracle Machine Learning.
5. Under Admin, select Manage OML Users to add Oracle Machine Learning Notebooks users.
6. Click Show All Users to display the existing database users.
   
   

   
   Description of the illustration dwcs_oml_show_all_users.png

   
   

   Note:

   Initially, the Role field shows the role None for existing database users. After adding a user the role Developer is assigned to the user.
7. Select a user. To select a user select a name in the User Name column. For example, select ANALYST1.
   Selecting the user shows the Oracle Machine Learning Edit User page.
8. Enter a name in the First Name field. (Optional)
9. Enter the last name of the user in the Last Name field. (Optional)
10. In the Email Address field, enter the email ID of the user.
    Making any change on this page adds the existing database user with the required privileges as an Oracle Machine Learning component user.
11. Click Save.

This grants the required privileges to use the Oracle Machine Learning application. In Oracle Machine Learning this user can then access any tables the user has privileges to access in the database.