CINXE.COM
Manage Users
<!DOCTYPE html SYSTEM "about:legacy-compat"> <html xml:lang="en-us" lang="en-us"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="DC.Type" content="topic"> <meta name="DC.Title" content="Manage Users"> <meta name="abstract" content="Describes administration tasks for managing database users on Autonomous Database."> <meta name="description" content="Describes administration tasks for managing database users on Autonomous Database."> <meta name="DC.Relation" scheme="URI" content="tasks.html"> <meta name="DC.Relation" scheme="URI" content="manage-users-create.html#GUID-B5846072-995B-4B81-BDCB-AF530BC42847"> <meta name="DC.Relation" scheme="URI" content="manage-users-remove.html#GUID-6384C752-648E-46FA-B772-3405DD4876A7"> <meta name="DC.Relation" scheme="URI" content="manage-user-profiles.html#GUID-BD3C5573-DF0E-4E44-919A-08A471462B87"> <meta name="DC.Relation" scheme="URI" content="manage-users-privileges.html#GUID-63669A4D-227E-4C0F-9794-1B2BC4106725"> <meta name="DC.Relation" scheme="URI" content="manage-users-oml.html#GUID-94476A16-F873-4079-831F-ED0580EA2CD4"> <meta name="DC.Relation" scheme="URI" content="manage-users-iam.html#GUID-4E206209-4E3B-4387-9364-BDCFB4E16E2E"> <meta name="DC.Relation" scheme="URI" content="manage-users-azure-ad.html#GUID-562655CA-4D8B-41D2-9165-6515BC824E07"> <meta name="DC.Relation" scheme="URI" content="manage-users-active-directory.html#GUID-11754210-CCD7-48B3-BC16-0E537A27217C"> <meta name="DC.Relation" scheme="URI" content="mdw-configure-kerberos-authentication-autonomous-database.html#GUID-B753639A-0FCA-4BCA-B31A-8D667E595ADD"> <meta name="DC.Publisher" content="November2024"> <meta name="template" content="Topic"> <meta name="DC.Format" content="XHTML"> <meta name="DC.Identifier" content="GUID-58DABEA3-9A17-4AA4-B32C-C0E301678A9E"> <meta name="DC.Language" content="en-US"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="abstract" content="Describes administration tasks for managing database users on Autonomous Database."> <meta name="description" content="Describes administration tasks for managing database users on Autonomous Database."> <title>Manage Users</title> <meta property="og:site_name" content="Oracle Help Center"> <meta property="og:title" content="Using Oracle Autonomous Database Serverless"> <meta property="og:description" content="Describes administration tasks for managing database users on Autonomous Database."> <link rel="stylesheet" href="/sp_common/book-template/ohc-book-template/css/book.css"> <link rel="shortcut icon" href="/sp_common/book-template/ohc-common/img/favicon.ico"> <meta name="application-name" content="Using Oracle Autonomous Database Serverless"> <meta name="generator" content="DITA Open Toolkit version 1.8.5 (Mode = doc)"> <meta name="plugin" content="SP_docbuilder HTML plugin release 18.2.2"> <link rel="alternate" href="using-oracle-autonomous-database-serverless.pdf" title="PDF File" type="application/pdf"> <link rel="schema.dcterms" href="http://purl.org/dc/terms/"> <meta name="dcterms.created" content="2024-11-26T10:36:55-08:00"> <meta name="dcterms.title" content="Using Oracle Autonomous Database Serverless"> <meta name="dcterms.dateCopyrighted" content="2022, 2024"> <meta name="dcterms.category" content="cloud"> <meta name="dcterms.identifier" content="F61232-80"> <meta name="dcterms.product" content="en/cloud/paas/autonomous-database/serverless"> <link rel="prev" href="view-network-information.html" title="Previous" type="text/html"> <link rel="next" href="manage-users-create.html" title="Next" type="text/html"> <script> document.write('<style type="text/css">'); document.write('body > .noscript, body > .noscript ~ * { visibility: hidden; }'); document.write('</style>'); </script> <script data-main="/sp_common/book-template/ohc-book-template/js/book-config" src="/sp_common/book-template/requirejs/require.js"></script> <script> if (window.require === undefined) { document.write('<script data-main="sp_common/book-template/ohc-book-template/js/book-config" src="sp_common/book-template/requirejs/require.js"><\/script>'); document.write('<link href="sp_common/book-template/ohc-book-template/css/book.css" rel="stylesheet"/>'); } </script> <script type="application/json" id="ssot-metadata">{"primary":{"category":{"short_name":"cloud","element_name":"Cloud","display_in_url":true},"suite":{"short_name":"paas","element_name":"Cloud Platform","display_in_url":true},"product_group":{"short_name":"autonomous-database","element_name":"Autonomous Database","display_in_url":true},"product":{"short_name":"serverless","element_name":"Serverless","display_in_url":true},"release":{"short_name":"latest","element_name":"Latest Cloud Release","display_in_url":false}}}</script> <meta name="dcterms.isVersionOf" content="ADBSB"> <meta name="dcterms.release" content="Latest Cloud Release"> <script type="application/ld+json"> {"@context":"https://schema.org","@type":"WebPage","name":"Manage Users","description":"Describes administration tasks for managing database users on Autonomous Database.","datePublished":"2023-08-02 CST","dateModified":"2024-11-26 CST"} </script> <script>window.ohcglobal || document.write('<script src="/en/dcommon/js/global.js">\x3C/script>')</script></head> <body> <div class="noscript alert alert-danger text-center" role="alert"> <a href="view-network-information.html" class="pull-left"><span class="glyphicon glyphicon-chevron-left" aria-hidden="true"></span>Previous</a> <a href="manage-users-create.html" class="pull-right">Next<span class="glyphicon glyphicon-chevron-right" aria-hidden="true"></span></a> <span class="fa fa-exclamation-triangle" aria-hidden="true"></span> JavaScript must be enabled to correctly display this content </div> <article> <header> <ol class="breadcrumb" vocab="http://schema.org/" typeof="BreadcrumbList"> <li property="itemListElement" typeof="ListItem"><a href="index.html" property="item" typeof="WebPage"><span property="name">Using Oracle Autonomous Database Serverless</span></a></li> <li property="itemListElement" typeof="ListItem"><a href="tasks.html" property="item" typeof="WebPage"><span property="name">Tasks</span></a></li> <li class="active" property="itemListElement" typeof="ListItem">Manage Users</li> </ol> <a id="GUID-58DABEA3-9A17-4AA4-B32C-C0E301678A9E" name="GUID-58DABEA3-9A17-4AA4-B32C-C0E301678A9E"></a> <h2 id="ADBSB-GUID-58DABEA3-9A17-4AA4-B32C-C0E301678A9E" class="sect2">Manage Users</h2> </header> <div class="ind"> <div> <p>Describes administration tasks for managing database users on <span>Autonomous Database</span>. </p> </div> <div> <ul class="ullinks"> <li class="ulchildlink"><a href="manage-users-create.html#GUID-B5846072-995B-4B81-BDCB-AF530BC42847">Create Users on Autonomous Database</a><br>There are several options to create users on <span>Autonomous Database</span>. You can use Oracle Database Actions Database Users card or use client-side tools that connect to the database to create database users. </li> <li class="ulchildlink"><a href="manage-users-remove.html#GUID-6384C752-648E-46FA-B772-3405DD4876A7">Remove Users on Autonomous Database</a><br>To remove users from your database, connect to the database as the <span>ADMIN</span> user using any SQL client tool. </li> <li class="ulchildlink"><a href="manage-user-profiles.html#GUID-BD3C5573-DF0E-4E44-919A-08A471462B87">Manage User Profiles with Autonomous Database</a><br>You can create and alter user profiles in <span>Autonomous Database</span>. After you create or alter a profile, you can specify the profile clause with <code class="codeph">CREATE USER</code> or <code class="codeph">ALTER USER</code>. You can also import existing user profiles from another environment with Oracle Data Pump Import. </li> <li class="ulchildlink"><a href="manage-users-privileges.html#GUID-63669A4D-227E-4C0F-9794-1B2BC4106725">Manage User Roles and Privileges on Autonomous Database</a><br>There are several ways to manage user privileges and roles on <span>Autonomous Database</span>. You can use Oracle Database Actions Database Users card or client-side tools to connect to the database to mange privileges and roles. </li> <li class="ulchildlink"><a href="manage-users-oml.html#GUID-94476A16-F873-4079-831F-ED0580EA2CD4">Create and Update User Accounts for Oracle Machine Learning Components on Autonomous Database</a><br>An administrator can add an existing database user account to use with <span>Oracle Machine Learning</span> components or create a new user account and user credentials with the <span>Oracle Machine Learning</span> User Management interface. </li> <li class="ulchildlink"><a href="manage-users-iam.html#GUID-4E206209-4E3B-4387-9364-BDCFB4E16E2E">Use Identity and Access Management (IAM) Authentication with Autonomous Database</a><br>You can configure <span>Autonomous Database</span> to use <span>Oracle Cloud Infrastructure Identity and Access Management</span> (IAM) authentication and authorization to allow IAM users to access an <span>Autonomous Database</span> with IAM credentials. </li> <li class="ulchildlink"><a href="manage-users-azure-ad.html#GUID-562655CA-4D8B-41D2-9165-6515BC824E07">Use Azure Active Directory (Azure AD) with Autonomous Database</a><br>You can configure an <span>Autonomous Database</span> instance for Azure AD users to connect using Azure OAuth2 access tokens. </li> <li class="ulchildlink"><a href="manage-users-active-directory.html#GUID-11754210-CCD7-48B3-BC16-0E537A27217C">Use Microsoft Active Directory with Autonomous Database</a><br>You can configure <span>Autonomous Database</span> to authenticate and authorize Microsoft Active Directory users. </li> <li class="ulchildlink"><a href="mdw-configure-kerberos-authentication-autonomous-database.html#GUID-B753639A-0FCA-4BCA-B31A-8D667E595ADD">Configure Kerberos Authentication with Autonomous Database</a><br>Describes how to configure Kerberos to authenticate <span>Oracle Autonomous Database</span> users. </li> </ul> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="tasks.html">Tasks</a></p> </div> </div> </div> </div> </article> </body> </html>