1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseUser
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseUser

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

    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: oci_database_management_managed_database.test_managed_database.id,
        userName: oci_identity_user.test_user.name,
        opcNamedCredentialId: _var.managed_database_user_opc_named_credential_id,
    });
    
    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"],
        opc_named_credential_id=var["managed_database_user_opc_named_credential_id"])
    
    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,
    			OpcNamedCredentialId: pulumi.StringRef(_var.Managed_database_user_opc_named_credential_id),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    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,
            OpcNamedCredentialId = @var.Managed_database_user_opc_named_credential_id,
        });
    
    });
    
    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())
                .opcNamedCredentialId(var_.managed_database_user_opc_named_credential_id())
                .build());
    
        }
    }
    
    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}
            opcNamedCredentialId: ${var.managed_database_user_opc_named_credential_id}
    

    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,
                                  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]
    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.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    UserName string
    The name of the user whose details are to be viewed.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    managedDatabaseId String
    The OCID of the Managed Database.
    userName String
    The name of the user whose details are to be viewed.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    managedDatabaseId string
    The OCID of the Managed Database.
    userName string
    The name of the user whose details are to be viewed.
    opcNamedCredentialId string
    The OCID of the Named Credential.
    managed_database_id str
    The OCID of the Managed Database.
    user_name str
    The name of the user whose details are to be viewed.
    opc_named_credential_id str
    The OCID of the Named Credential.
    managedDatabaseId String
    The OCID of the Managed Database.
    userName 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.
    oci logo
    Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi