Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getManagedDatabaseUser

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

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testManagedDatabaseUser = Output.Create(Oci.DatabaseManagement.GetManagedDatabaseUser.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabaseUserArgs
        {
            ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
            UserName = oci_identity_user.Test_user.Name,
        }));
    }

}
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/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: oci_database_management_managed_database.Test_managed_database.Id,
			UserName:          oci_identity_user.Test_user.Name,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

import pulumi
import pulumi_oci as oci

test_managed_database_user = oci.DatabaseManagement.get_managed_database_user(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
    user_name=oci_identity_user["test_user"]["name"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseUser = oci.DatabaseManagement.getManagedDatabaseUser({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    userName: oci_identity_user.test_user.name,
});

Coming soon!

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>
def get_managed_database_user(managed_database_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,
                              user_name: Optional[pulumi.Input[str]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseUserResult]
func GetManagedDatabaseUser(ctx *Context, args *GetManagedDatabaseUserArgs, opts ...InvokeOption) (*GetManagedDatabaseUserResult, error)
func GetManagedDatabaseUserOutput(ctx *Context, args *GetManagedDatabaseUserOutputArgs, opts ...InvokeOption) GetManagedDatabaseUserResultOutput

> 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)
}
public static CompletableFuture<GetManagedDatabaseUserResult> getManagedDatabaseUser(GetManagedDatabaseUserArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:DatabaseManagement/getManagedDatabaseUser:getManagedDatabaseUser
  Arguments:
    # Arguments dictionary

The following arguments are supported:

ManagedDatabaseId string

The OCID of the Managed Database.

UserName string

The name of the user whose details are to be viewed.

ManagedDatabaseId string

The OCID of the Managed Database.

UserName string

The name of the user whose details are to be viewed.

managedDatabaseId String

The OCID of the Managed Database.

userName String

The name of the user whose details are to be viewed.

managedDatabaseId string

The OCID of the Managed Database.

userName string

The name of the user whose details are to be viewed.

managed_database_id str

The OCID of the Managed Database.

user_name str

The name of the user whose details are to be viewed.

managedDatabaseId String

The OCID of the Managed Database.

userName String

The name of the user whose details are to be viewed.

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 User resource profile name.

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 account status was 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
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 User resource profile name.

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 account status was 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
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 User resource profile name.

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 account status was 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
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 User resource profile name.

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 account status was 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
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 User resource profile name.

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 account status was 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
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 User resource profile name.

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 account status was 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

Package Details

Repository
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.