Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseUser
Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseUser

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi
pulumi/pulumi-oci

This data source provides details about a specific Managed Database User resource in Oracle Cloud Infrastructure Database Management service.

Gets the details of the user specified by managedDatabaseId and userName.

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseUser = oci.DatabaseManagement.getManagedDatabaseUser({
    managedDatabaseId: testManagedDatabase.id,
    userName: testUser.name,
    opcNamedCredentialId: managedDatabaseUserOpcNamedCredentialId,
});
Copy
import pulumi
import pulumi_oci as oci

test_managed_database_user = oci.DatabaseManagement.get_managed_database_user(managed_database_id=test_managed_database["id"],
    user_name=test_user["name"],
    opc_named_credential_id=managed_database_user_opc_named_credential_id)
Copy
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/databasemanagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasemanagement.GetManagedDatabaseUser(ctx, &databasemanagement.GetManagedDatabaseUserArgs{
			ManagedDatabaseId:    testManagedDatabase.Id,
			UserName:             testUser.Name,
			OpcNamedCredentialId: pulumi.StringRef(managedDatabaseUserOpcNamedCredentialId),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseUser = Oci.DatabaseManagement.GetManagedDatabaseUser.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        UserName = testUser.Name,
        OpcNamedCredentialId = managedDatabaseUserOpcNamedCredentialId,
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetManagedDatabaseUserArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testManagedDatabaseUser = DatabaseManagementFunctions.getManagedDatabaseUser(GetManagedDatabaseUserArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .userName(testUser.name())
            .opcNamedCredentialId(managedDatabaseUserOpcNamedCredentialId)
            .build());

    }
}
Copy
variables:
  testManagedDatabaseUser:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseUser
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        userName: ${testUser.name}
        opcNamedCredentialId: ${managedDatabaseUserOpcNamedCredentialId}
Copy

Using getManagedDatabaseUser

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getManagedDatabaseUser(args: GetManagedDatabaseUserArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseUserResult>
function getManagedDatabaseUserOutput(args: GetManagedDatabaseUserOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseUserResult>
Copy
def get_managed_database_user(managed_database_id: Optional[str] = None,
                              opc_named_credential_id: Optional[str] = None,
                              user_name: Optional[str] = None,
                              opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseUserResult
def get_managed_database_user_output(managed_database_id: Optional[pulumi.Input[str]] = None,
                              opc_named_credential_id: Optional[pulumi.Input[str]] = None,
                              user_name: Optional[pulumi.Input[str]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseUserResult]
Copy
func GetManagedDatabaseUser(ctx *Context, args *GetManagedDatabaseUserArgs, opts ...InvokeOption) (*GetManagedDatabaseUserResult, error)
func GetManagedDatabaseUserOutput(ctx *Context, args *GetManagedDatabaseUserOutputArgs, opts ...InvokeOption) GetManagedDatabaseUserResultOutput
Copy

> Note: This function is named GetManagedDatabaseUser in the Go SDK.

public static class GetManagedDatabaseUser 
{
    public static Task<GetManagedDatabaseUserResult> InvokeAsync(GetManagedDatabaseUserArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseUserResult> Invoke(GetManagedDatabaseUserInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetManagedDatabaseUserResult> getManagedDatabaseUser(GetManagedDatabaseUserArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseUserResult> getManagedDatabaseUser(GetManagedDatabaseUserArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseUser:getManagedDatabaseUser
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

ManagedDatabaseId This property is required. string
The OCID of the Managed Database.
UserName This property is required. string
The name of the user whose details are to be viewed.
OpcNamedCredentialId string
The OCID of the Named Credential.
ManagedDatabaseId This property is required. string
The OCID of the Managed Database.
UserName This property is required. string
The name of the user whose details are to be viewed.
OpcNamedCredentialId string
The OCID of the Named Credential.
managedDatabaseId This property is required. String
The OCID of the Managed Database.
userName This property is required. String
The name of the user whose details are to be viewed.
opcNamedCredentialId String
The OCID of the Named Credential.
managedDatabaseId This property is required. string
The OCID of the Managed Database.
userName This property is required. string
The name of the user whose details are to be viewed.
opcNamedCredentialId string
The OCID of the Named Credential.
managed_database_id This property is required. str
The OCID of the Managed Database.
user_name This property is required. str
The name of the user whose details are to be viewed.
opc_named_credential_id str
The OCID of the Named Credential.
managedDatabaseId This property is required. String
The OCID of the Managed Database.
userName This property is required. String
The name of the user whose details are to be viewed.
opcNamedCredentialId String
The OCID of the Named Credential.

getManagedDatabaseUser Result

The following output properties are available:

AllShared string
In a sharded database, indicates whether the user is created with shard DDL enabled (YES) or not (NO).
Authentication string
The authentication mechanism for the user.
Common string
Indicates whether a given user is common(Y) or local(N).
ConsumerGroup string
The initial resource consumer group for the User.
DefaultCollation string
The default collation for the user schema.
DefaultTablespace string
The default tablespace for data.
EditionsEnabled string
Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
ExternalName string
The external name of the user.
ExternalShared string
In a federated sharded database, indicates whether the user is an external shard user (YES) or not (NO).
Id string
The provider-assigned unique ID for this managed resource.
Implicit string
Indicates whether the user is a common user created by an implicit application (YES) or not (NO).
Inherited string
Indicates whether the user definition is inherited from another container (YES) or not (NO).
LocalTempTablespace string
The default local temporary tablespace for the user.
ManagedDatabaseId string
Name string
The name of the User.
OracleMaintained string
Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
PasswordVersions string
The list of existing versions of the password hashes (also known as "verifiers") for the account.
Profile string
The profile name of the user.
ProxyConnect string
Indicates whether a user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account (that is, by users who have been granted the "connect through" privilege for this account).
Status string
The status of the user account.
TempTablespace string
The name of the default tablespace for temporary tables or the name of a tablespace group.
TimeCreated string
The date and time the user was created.
TimeExpiring string
The date and time of the expiration of the user account.
TimeLastLogin string
The date and time of the last user login. This column is not populated when a user connects to the database with administrative privileges, that is, AS { SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSRAC | SYSKM }.
TimeLocked string
The date the account was locked, if the status of the account is LOCKED.
TimePasswordChanged string
The date and time when the user password was last set. This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, this column is null.
UserName string
OpcNamedCredentialId string
AllShared string
In a sharded database, indicates whether the user is created with shard DDL enabled (YES) or not (NO).
Authentication string
The authentication mechanism for the user.
Common string
Indicates whether a given user is common(Y) or local(N).
ConsumerGroup string
The initial resource consumer group for the User.
DefaultCollation string
The default collation for the user schema.
DefaultTablespace string
The default tablespace for data.
EditionsEnabled string
Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
ExternalName string
The external name of the user.
ExternalShared string
In a federated sharded database, indicates whether the user is an external shard user (YES) or not (NO).
Id string
The provider-assigned unique ID for this managed resource.
Implicit string
Indicates whether the user is a common user created by an implicit application (YES) or not (NO).
Inherited string
Indicates whether the user definition is inherited from another container (YES) or not (NO).
LocalTempTablespace string
The default local temporary tablespace for the user.
ManagedDatabaseId string
Name string
The name of the User.
OracleMaintained string
Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
PasswordVersions string
The list of existing versions of the password hashes (also known as "verifiers") for the account.
Profile string
The profile name of the user.
ProxyConnect string
Indicates whether a user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account (that is, by users who have been granted the "connect through" privilege for this account).
Status string
The status of the user account.
TempTablespace string
The name of the default tablespace for temporary tables or the name of a tablespace group.
TimeCreated string
The date and time the user was created.
TimeExpiring string
The date and time of the expiration of the user account.
TimeLastLogin string
The date and time of the last user login. This column is not populated when a user connects to the database with administrative privileges, that is, AS { SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSRAC | SYSKM }.
TimeLocked string
The date the account was locked, if the status of the account is LOCKED.
TimePasswordChanged string
The date and time when the user password was last set. This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, this column is null.
UserName string
OpcNamedCredentialId string
allShared String
In a sharded database, indicates whether the user is created with shard DDL enabled (YES) or not (NO).
authentication String
The authentication mechanism for the user.
common String
Indicates whether a given user is common(Y) or local(N).
consumerGroup String
The initial resource consumer group for the User.
defaultCollation String
The default collation for the user schema.
defaultTablespace String
The default tablespace for data.
editionsEnabled String
Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
externalName String
The external name of the user.
externalShared String
In a federated sharded database, indicates whether the user is an external shard user (YES) or not (NO).
id String
The provider-assigned unique ID for this managed resource.
implicit String
Indicates whether the user is a common user created by an implicit application (YES) or not (NO).
inherited String
Indicates whether the user definition is inherited from another container (YES) or not (NO).
localTempTablespace String
The default local temporary tablespace for the user.
managedDatabaseId String
name String
The name of the User.
oracleMaintained String
Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
passwordVersions String
The list of existing versions of the password hashes (also known as "verifiers") for the account.
profile String
The profile name of the user.
proxyConnect String
Indicates whether a user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account (that is, by users who have been granted the "connect through" privilege for this account).
status String
The status of the user account.
tempTablespace String
The name of the default tablespace for temporary tables or the name of a tablespace group.
timeCreated String
The date and time the user was created.
timeExpiring String
The date and time of the expiration of the user account.
timeLastLogin String
The date and time of the last user login. This column is not populated when a user connects to the database with administrative privileges, that is, AS { SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSRAC | SYSKM }.
timeLocked String
The date the account was locked, if the status of the account is LOCKED.
timePasswordChanged String
The date and time when the user password was last set. This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, this column is null.
userName String
opcNamedCredentialId String
allShared string
In a sharded database, indicates whether the user is created with shard DDL enabled (YES) or not (NO).
authentication string
The authentication mechanism for the user.
common string
Indicates whether a given user is common(Y) or local(N).
consumerGroup string
The initial resource consumer group for the User.
defaultCollation string
The default collation for the user schema.
defaultTablespace string
The default tablespace for data.
editionsEnabled string
Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
externalName string
The external name of the user.
externalShared string
In a federated sharded database, indicates whether the user is an external shard user (YES) or not (NO).
id string
The provider-assigned unique ID for this managed resource.
implicit string
Indicates whether the user is a common user created by an implicit application (YES) or not (NO).
inherited string
Indicates whether the user definition is inherited from another container (YES) or not (NO).
localTempTablespace string
The default local temporary tablespace for the user.
managedDatabaseId string
name string
The name of the User.
oracleMaintained string
Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
passwordVersions string
The list of existing versions of the password hashes (also known as "verifiers") for the account.
profile string
The profile name of the user.
proxyConnect string
Indicates whether a user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account (that is, by users who have been granted the "connect through" privilege for this account).
status string
The status of the user account.
tempTablespace string
The name of the default tablespace for temporary tables or the name of a tablespace group.
timeCreated string
The date and time the user was created.
timeExpiring string
The date and time of the expiration of the user account.
timeLastLogin string
The date and time of the last user login. This column is not populated when a user connects to the database with administrative privileges, that is, AS { SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSRAC | SYSKM }.
timeLocked string
The date the account was locked, if the status of the account is LOCKED.
timePasswordChanged string
The date and time when the user password was last set. This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, this column is null.
userName string
opcNamedCredentialId string
all_shared str
In a sharded database, indicates whether the user is created with shard DDL enabled (YES) or not (NO).
authentication str
The authentication mechanism for the user.
common str
Indicates whether a given user is common(Y) or local(N).
consumer_group str
The initial resource consumer group for the User.
default_collation str
The default collation for the user schema.
default_tablespace str
The default tablespace for data.
editions_enabled str
Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
external_name str
The external name of the user.
external_shared str
In a federated sharded database, indicates whether the user is an external shard user (YES) or not (NO).
id str
The provider-assigned unique ID for this managed resource.
implicit str
Indicates whether the user is a common user created by an implicit application (YES) or not (NO).
inherited str
Indicates whether the user definition is inherited from another container (YES) or not (NO).
local_temp_tablespace str
The default local temporary tablespace for the user.
managed_database_id str
name str
The name of the User.
oracle_maintained str
Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
password_versions str
The list of existing versions of the password hashes (also known as "verifiers") for the account.
profile str
The profile name of the user.
proxy_connect str
Indicates whether a user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account (that is, by users who have been granted the "connect through" privilege for this account).
status str
The status of the user account.
temp_tablespace str
The name of the default tablespace for temporary tables or the name of a tablespace group.
time_created str
The date and time the user was created.
time_expiring str
The date and time of the expiration of the user account.
time_last_login str
The date and time of the last user login. This column is not populated when a user connects to the database with administrative privileges, that is, AS { SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSRAC | SYSKM }.
time_locked str
The date the account was locked, if the status of the account is LOCKED.
time_password_changed str
The date and time when the user password was last set. This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, this column is null.
user_name str
opc_named_credential_id str
allShared String
In a sharded database, indicates whether the user is created with shard DDL enabled (YES) or not (NO).
authentication String
The authentication mechanism for the user.
common String
Indicates whether a given user is common(Y) or local(N).
consumerGroup String
The initial resource consumer group for the User.
defaultCollation String
The default collation for the user schema.
defaultTablespace String
The default tablespace for data.
editionsEnabled String
Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
externalName String
The external name of the user.
externalShared String
In a federated sharded database, indicates whether the user is an external shard user (YES) or not (NO).
id String
The provider-assigned unique ID for this managed resource.
implicit String
Indicates whether the user is a common user created by an implicit application (YES) or not (NO).
inherited String
Indicates whether the user definition is inherited from another container (YES) or not (NO).
localTempTablespace String
The default local temporary tablespace for the user.
managedDatabaseId String
name String
The name of the User.
oracleMaintained String
Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
passwordVersions String
The list of existing versions of the password hashes (also known as "verifiers") for the account.
profile String
The profile name of the user.
proxyConnect String
Indicates whether a user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account (that is, by users who have been granted the "connect through" privilege for this account).
status String
The status of the user account.
tempTablespace String
The name of the default tablespace for temporary tables or the name of a tablespace group.
timeCreated String
The date and time the user was created.
timeExpiring String
The date and time of the expiration of the user account.
timeLastLogin String
The date and time of the last user login. This column is not populated when a user connects to the database with administrative privileges, that is, AS { SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSRAC | SYSKM }.
timeLocked String
The date the account was locked, if the status of the account is LOCKED.
timePasswordChanged String
The date and time when the user password was last set. This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, this column is null.
userName String
opcNamedCredentialId String

Package Details

Repository
oci pulumi/pulumi-oci
License
Apache-2.0
Notes
This Pulumi package is based on the oci Terraform Provider.
Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi
pulumi/pulumi-oci