oci.DatabaseManagement.getManagedDatabaseUser
Explore with Pulumi AI
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:
- Managed
Database stringId The OCID of the Managed Database.
- User
Name string The name of the user whose details are to be viewed.
- Managed
Database stringId The OCID of the Managed Database.
- User
Name string The name of the user whose details are to be viewed.
- managed
Database StringId The OCID of the Managed Database.
- user
Name String The name of the user whose details are to be viewed.
- managed
Database stringId The OCID of the Managed Database.
- user
Name string The name of the user whose details are to be viewed.
- managed_
database_ strid The OCID of the Managed Database.
- user_
name str The name of the user whose details are to be viewed.
- managed
Database StringId The OCID of the Managed Database.
- user
Name String The name of the user whose details are to be viewed.
getManagedDatabaseUser Result
The following output properties are available:
- 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).
- Consumer
Group string The initial resource consumer group for the User.
- Default
Collation string The default collation for the user schema.
- Default
Tablespace string The default tablespace for data.
- Editions
Enabled string Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
- External
Name string The external name of the user.
- 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).
- Local
Temp stringTablespace The default local temporary tablespace for the user.
- Managed
Database stringId - Name string
The name of the User.
- Oracle
Maintained string Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
- Password
Versions 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.
- Proxy
Connect 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.
- Temp
Tablespace string The name of the default tablespace for temporary tables or the name of a tablespace group.
- Time
Created string The date and time the user was created.
- Time
Expiring string The date and time of the expiration of the user account.
- Time
Last stringLogin 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 string The date the account was locked, if the status of the account is LOCKED.
- Time
Password stringChanged 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 string
- 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).
- Consumer
Group string The initial resource consumer group for the User.
- Default
Collation string The default collation for the user schema.
- Default
Tablespace string The default tablespace for data.
- Editions
Enabled string Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
- External
Name string The external name of the user.
- 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).
- Local
Temp stringTablespace The default local temporary tablespace for the user.
- Managed
Database stringId - Name string
The name of the User.
- Oracle
Maintained string Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
- Password
Versions 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.
- Proxy
Connect 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.
- Temp
Tablespace string The name of the default tablespace for temporary tables or the name of a tablespace group.
- Time
Created string The date and time the user was created.
- Time
Expiring string The date and time of the expiration of the user account.
- Time
Last stringLogin 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 string The date the account was locked, if the status of the account is LOCKED.
- Time
Password stringChanged 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 string
- 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).
- consumer
Group String The initial resource consumer group for the User.
- default
Collation String The default collation for the user schema.
- default
Tablespace String The default tablespace for data.
- editions
Enabled String Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
- external
Name String The external name of the user.
- 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).
- local
Temp StringTablespace The default local temporary tablespace for the user.
- managed
Database StringId - name String
The name of the User.
- oracle
Maintained String Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
- password
Versions 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.
- proxy
Connect 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.
- temp
Tablespace String The name of the default tablespace for temporary tables or the name of a tablespace group.
- time
Created String The date and time the user was created.
- time
Expiring String The date and time of the expiration of the user account.
- time
Last StringLogin 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 String The date the account was locked, if the status of the account is LOCKED.
- time
Password StringChanged 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 String
- 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).
- consumer
Group string The initial resource consumer group for the User.
- default
Collation string The default collation for the user schema.
- default
Tablespace string The default tablespace for data.
- editions
Enabled string Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
- external
Name string The external name of the user.
- 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).
- local
Temp stringTablespace The default local temporary tablespace for the user.
- managed
Database stringId - name string
The name of the User.
- oracle
Maintained string Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
- password
Versions 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.
- proxy
Connect 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.
- temp
Tablespace string The name of the default tablespace for temporary tables or the name of a tablespace group.
- time
Created string The date and time the user was created.
- time
Expiring string The date and time of the expiration of the user account.
- time
Last stringLogin 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 string The date the account was locked, if the status of the account is LOCKED.
- time
Password stringChanged 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 string
- 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.
- 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_ strtablespace The default local temporary tablespace for the user.
- managed_
database_ strid - 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_ strlogin 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_ strchanged 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
- 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).
- consumer
Group String The initial resource consumer group for the User.
- default
Collation String The default collation for the user schema.
- default
Tablespace String The default tablespace for data.
- editions
Enabled String Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
- external
Name String The external name of the user.
- 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).
- local
Temp StringTablespace The default local temporary tablespace for the user.
- managed
Database StringId - name String
The name of the User.
- oracle
Maintained String Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
- password
Versions 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.
- proxy
Connect 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.
- temp
Tablespace String The name of the default tablespace for temporary tables or the name of a tablespace group.
- time
Created String The date and time the user was created.
- time
Expiring String The date and time of the expiration of the user account.
- time
Last StringLogin 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 String The date the account was locked, if the status of the account is LOCKED.
- time
Password StringChanged 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 String
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
oci
Terraform Provider.