1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseUser
Oracle Cloud Infrastructure v0.20.1 published on Tuesday, Jun 6, 2023 by Pulumi

oci.DatabaseManagement.getManagedDatabaseUser

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v0.20.1 published on Tuesday, Jun 6, 2023 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

    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.

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