Oracle Cloud Infrastructure v2.33.0, May 1 25

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabasesUserSystemPrivilege

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabasesUserSystemPrivilege = oci.DatabaseManagement.getManagedDatabasesUserSystemPrivilege({
    managedDatabaseId: testManagedDatabase.id,
    userName: testUser.name,
    name: managedDatabasesUserSystemPrivilegeName,
});

import pulumi
import pulumi_oci as oci

test_managed_databases_user_system_privilege = oci.DatabaseManagement.get_managed_databases_user_system_privilege(managed_database_id=test_managed_database["id"],
    user_name=test_user["name"],
    name=managed_databases_user_system_privilege_name)

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/databasemanagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasemanagement.GetManagedDatabasesUserSystemPrivilege(ctx, &databasemanagement.GetManagedDatabasesUserSystemPrivilegeArgs{
			ManagedDatabaseId: testManagedDatabase.Id,
			UserName:          testUser.Name,
			Name:              pulumi.StringRef(managedDatabasesUserSystemPrivilegeName),
		}, 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 testManagedDatabasesUserSystemPrivilege = Oci.DatabaseManagement.GetManagedDatabasesUserSystemPrivilege.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        UserName = testUser.Name,
        Name = managedDatabasesUserSystemPrivilegeName,
    });

});

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.GetManagedDatabasesUserSystemPrivilegeArgs;
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 testManagedDatabasesUserSystemPrivilege = DatabaseManagementFunctions.getManagedDatabasesUserSystemPrivilege(GetManagedDatabasesUserSystemPrivilegeArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .userName(testUser.name())
            .name(managedDatabasesUserSystemPrivilegeName)
            .build());

    }
}

variables:
  testManagedDatabasesUserSystemPrivilege:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabasesUserSystemPrivilege
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        userName: ${testUser.name}
        name: ${managedDatabasesUserSystemPrivilegeName}

Using getManagedDatabasesUserSystemPrivilege

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 getManagedDatabasesUserSystemPrivilege(args: GetManagedDatabasesUserSystemPrivilegeArgs, opts?: InvokeOptions): Promise<GetManagedDatabasesUserSystemPrivilegeResult>
function getManagedDatabasesUserSystemPrivilegeOutput(args: GetManagedDatabasesUserSystemPrivilegeOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabasesUserSystemPrivilegeResult>

def get_managed_databases_user_system_privilege(managed_database_id: Optional[str] = None,
                                                name: Optional[str] = None,
                                                user_name: Optional[str] = None,
                                                opts: Optional[InvokeOptions] = None) -> GetManagedDatabasesUserSystemPrivilegeResult
def get_managed_databases_user_system_privilege_output(managed_database_id: Optional[pulumi.Input[str]] = None,
                                                name: Optional[pulumi.Input[str]] = None,
                                                user_name: Optional[pulumi.Input[str]] = None,
                                                opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabasesUserSystemPrivilegeResult]

func GetManagedDatabasesUserSystemPrivilege(ctx *Context, args *GetManagedDatabasesUserSystemPrivilegeArgs, opts ...InvokeOption) (*GetManagedDatabasesUserSystemPrivilegeResult, error)
func GetManagedDatabasesUserSystemPrivilegeOutput(ctx *Context, args *GetManagedDatabasesUserSystemPrivilegeOutputArgs, opts ...InvokeOption) GetManagedDatabasesUserSystemPrivilegeResultOutput

> Note: This function is named GetManagedDatabasesUserSystemPrivilege in the Go SDK.

public static class GetManagedDatabasesUserSystemPrivilege 
{
    public static Task<GetManagedDatabasesUserSystemPrivilegeResult> InvokeAsync(GetManagedDatabasesUserSystemPrivilegeArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabasesUserSystemPrivilegeResult> Invoke(GetManagedDatabasesUserSystemPrivilegeInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetManagedDatabasesUserSystemPrivilegeResult> getManagedDatabasesUserSystemPrivilege(GetManagedDatabasesUserSystemPrivilegeArgs args, InvokeOptions options)
public static Output<GetManagedDatabasesUserSystemPrivilegeResult> getManagedDatabasesUserSystemPrivilege(GetManagedDatabasesUserSystemPrivilegeArgs args, InvokeOptions options)

fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabasesUserSystemPrivilege:getManagedDatabasesUserSystemPrivilege
  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.
Name string: A filter to return only resources that match the entire name.

ManagedDatabaseId string: The OCID of the Managed Database.
UserName string: The name of the user whose details are to be viewed.
Name string: A filter to return only resources that match the entire name.

managedDatabaseId String: The OCID of the Managed Database.
userName String: The name of the user whose details are to be viewed.
name String: A filter to return only resources that match the entire name.

managedDatabaseId string: The OCID of the Managed Database.
userName string: The name of the user whose details are to be viewed.
name string: A filter to return only resources that match the entire name.

managed_database_id str: The OCID of the Managed Database.
user_name str: The name of the user whose details are to be viewed.
name str: A filter to return only resources that match the entire name.

managedDatabaseId String: The OCID of the Managed Database.
userName String: The name of the user whose details are to be viewed.
name String: A filter to return only resources that match the entire name.

getManagedDatabasesUserSystemPrivilege Result

The following output properties are available:

Id string: The provider-assigned unique ID for this managed resource.
Items List<GetManagedDatabasesUserSystemPrivilegeItem>: An array of system privileges.
ManagedDatabaseId string
UserName string
Name string: The name of a system privilege.

Id string: The provider-assigned unique ID for this managed resource.
Items []GetManagedDatabasesUserSystemPrivilegeItem: An array of system privileges.
ManagedDatabaseId string
UserName string
Name string: The name of a system privilege.

id String: The provider-assigned unique ID for this managed resource.
items List<GetManagedDatabasesUserSystemPrivilegeItem>: An array of system privileges.
managedDatabaseId String
userName String
name String: The name of a system privilege.

id string: The provider-assigned unique ID for this managed resource.
items GetManagedDatabasesUserSystemPrivilegeItem[]: An array of system privileges.
managedDatabaseId string
userName string
name string: The name of a system privilege.

id str: The provider-assigned unique ID for this managed resource.
items Sequence[GetManagedDatabasesUserSystemPrivilegeItem]: An array of system privileges.
managed_database_id str
user_name str
name str: The name of a system privilege.

id String: The provider-assigned unique ID for this managed resource.
items List<Property Map>: An array of system privileges.
managedDatabaseId String
userName String
name String: The name of a system privilege.

Supporting Types

GetManagedDatabasesUserSystemPrivilegeItem

AdminOption string: Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
Common string: Indicates how the system privilege was granted. Possible values: YES if the system privilege is granted commonly (CONTAINER=ALL is used) NO if the system privilege is granted locally (CONTAINER=ALL is not used)
Inherited string: Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
Name string: A filter to return only resources that match the entire name.

AdminOption string: Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
Common string: Indicates how the system privilege was granted. Possible values: YES if the system privilege is granted commonly (CONTAINER=ALL is used) NO if the system privilege is granted locally (CONTAINER=ALL is not used)
Inherited string: Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
Name string: A filter to return only resources that match the entire name.

adminOption String: Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
common String: Indicates how the system privilege was granted. Possible values: YES if the system privilege is granted commonly (CONTAINER=ALL is used) NO if the system privilege is granted locally (CONTAINER=ALL is not used)
inherited String: Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
name String: A filter to return only resources that match the entire name.

adminOption string: Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
common string: Indicates how the system privilege was granted. Possible values: YES if the system privilege is granted commonly (CONTAINER=ALL is used) NO if the system privilege is granted locally (CONTAINER=ALL is not used)
inherited string: Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
name string: A filter to return only resources that match the entire name.

admin_option str: Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
common str: Indicates how the system privilege was granted. Possible values: YES if the system privilege is granted commonly (CONTAINER=ALL is used) NO if the system privilege is granted locally (CONTAINER=ALL is not used)
inherited str: Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
name str: A filter to return only resources that match the entire name.

adminOption String: Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
common String: Indicates how the system privilege was granted. Possible values: YES if the system privilege is granted commonly (CONTAINER=ALL is used) NO if the system privilege is granted locally (CONTAINER=ALL is not used)
inherited String: Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
name String: A filter to return only resources that match the entire name.

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 v2.33.0 published on Thursday, May 1, 2025 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabasesUserSystemPrivilege

On this page

On this page

Example Usage

Using getManagedDatabasesUserSystemPrivilege

getManagedDatabasesUserSystemPrivilege Result

Supporting Types

GetManagedDatabasesUserSystemPrivilegeItem

Package Details

On this page

On this page