oci.DatabaseManagement.getManagedDatabaseUser

Explore with Pulumi AI

Oracle Cloud Infrastructure v0.20.1 published on Tuesday, Jun 6, 2023 by Pulumi

Example Usage

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 = 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
	})
}

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(oci_database_management_managed_database.test_managed_database().id())
            .userName(oci_identity_user.test_user().name())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_managed_database_user = oci.DatabaseManagement.get_managed_database_user(managed_database_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    user_name=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))

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,
});

variables:
  testManagedDatabaseUser:
    fn::invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseUser
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        userName: ${oci_identity_user.test_user.name}

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 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

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

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

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

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

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

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 v0.20.1 published on Tuesday, Jun 6, 2023 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseUser

On this page

On this page

Example Usage

Using getManagedDatabaseUser

getManagedDatabaseUser Result

Package Details

On this page

On this page