Oracle Cloud Infrastructure Documentation

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.

Parent topic: Manage Users

Create User

An administrator creates new user accounts and user credentials for Oracle Machine Learning in Database Actions.

To create a user account:

  1. On the Autonomous Databases page, under the Display Name column, select an Autonomous Database.
  2. On the Autonomous Database Details page, select Database Actions and click Database Users.
  3. On the Database Users page, in the All Users area click + Create User.
  4. To create a new user enter a user name, a password, and enter the password again to confirm the password.
  5. Select the options you want for the user and select OML to enable Oracle Machine Learning for the user.


    Description of adb_databaseactions_create_oml_user.png follows

  6. 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 to provide access to Oracle Machine Learning components.

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, select Database Actions and click Database Users.
  3. In the All Users, search for the user of interest or select the user. For example, search the user OML_ANALYST.
  4. In the user's card, click more actions and select Edit
  5. In the Edit User panel, select OML.

    For example:


    Description of adb_databaseactions_edit_oml_user.png follows

  6. Click Apply Changes.

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.