Oracle Cloud Infrastructure v2.27.0, Mar 20 25

Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabaseUserConsumerGroupPrivileges

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi

Example Usage

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

const testManagedDatabaseUserConsumerGroupPrivileges = oci.DatabaseManagement.getManagedDatabaseUserConsumerGroupPrivileges({
    managedDatabaseId: testManagedDatabase.id,
    userName: testUser.name,
    name: managedDatabaseUserConsumerGroupPrivilegeName,
    opcNamedCredentialId: managedDatabaseUserConsumerGroupPrivilegeOpcNamedCredentialId,
});

import pulumi
import pulumi_oci as oci

test_managed_database_user_consumer_group_privileges = oci.DatabaseManagement.get_managed_database_user_consumer_group_privileges(managed_database_id=test_managed_database["id"],
    user_name=test_user["name"],
    name=managed_database_user_consumer_group_privilege_name,
    opc_named_credential_id=managed_database_user_consumer_group_privilege_opc_named_credential_id)

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.GetManagedDatabaseUserConsumerGroupPrivileges(ctx, &databasemanagement.GetManagedDatabaseUserConsumerGroupPrivilegesArgs{
			ManagedDatabaseId:    testManagedDatabase.Id,
			UserName:             testUser.Name,
			Name:                 pulumi.StringRef(managedDatabaseUserConsumerGroupPrivilegeName),
			OpcNamedCredentialId: pulumi.StringRef(managedDatabaseUserConsumerGroupPrivilegeOpcNamedCredentialId),
		}, 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 testManagedDatabaseUserConsumerGroupPrivileges = Oci.DatabaseManagement.GetManagedDatabaseUserConsumerGroupPrivileges.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        UserName = testUser.Name,
        Name = managedDatabaseUserConsumerGroupPrivilegeName,
        OpcNamedCredentialId = managedDatabaseUserConsumerGroupPrivilegeOpcNamedCredentialId,
    });

});

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.GetManagedDatabaseUserConsumerGroupPrivilegesArgs;
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 testManagedDatabaseUserConsumerGroupPrivileges = DatabaseManagementFunctions.getManagedDatabaseUserConsumerGroupPrivileges(GetManagedDatabaseUserConsumerGroupPrivilegesArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .userName(testUser.name())
            .name(managedDatabaseUserConsumerGroupPrivilegeName)
            .opcNamedCredentialId(managedDatabaseUserConsumerGroupPrivilegeOpcNamedCredentialId)
            .build());

    }
}

variables:
  testManagedDatabaseUserConsumerGroupPrivileges:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseUserConsumerGroupPrivileges
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        userName: ${testUser.name}
        name: ${managedDatabaseUserConsumerGroupPrivilegeName}
        opcNamedCredentialId: ${managedDatabaseUserConsumerGroupPrivilegeOpcNamedCredentialId}

Using getManagedDatabaseUserConsumerGroupPrivileges

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 getManagedDatabaseUserConsumerGroupPrivileges(args: GetManagedDatabaseUserConsumerGroupPrivilegesArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseUserConsumerGroupPrivilegesResult>
function getManagedDatabaseUserConsumerGroupPrivilegesOutput(args: GetManagedDatabaseUserConsumerGroupPrivilegesOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseUserConsumerGroupPrivilegesResult>

def get_managed_database_user_consumer_group_privileges(filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseUserConsumerGroupPrivilegesFilter]] = None,
                                                        managed_database_id: Optional[str] = None,
                                                        name: Optional[str] = None,
                                                        opc_named_credential_id: Optional[str] = None,
                                                        user_name: Optional[str] = None,
                                                        opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseUserConsumerGroupPrivilegesResult
def get_managed_database_user_consumer_group_privileges_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseUserConsumerGroupPrivilegesFilterArgs]]]] = None,
                                                        managed_database_id: Optional[pulumi.Input[str]] = None,
                                                        name: 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[GetManagedDatabaseUserConsumerGroupPrivilegesResult]

func GetManagedDatabaseUserConsumerGroupPrivileges(ctx *Context, args *GetManagedDatabaseUserConsumerGroupPrivilegesArgs, opts ...InvokeOption) (*GetManagedDatabaseUserConsumerGroupPrivilegesResult, error)
func GetManagedDatabaseUserConsumerGroupPrivilegesOutput(ctx *Context, args *GetManagedDatabaseUserConsumerGroupPrivilegesOutputArgs, opts ...InvokeOption) GetManagedDatabaseUserConsumerGroupPrivilegesResultOutput

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

public static class GetManagedDatabaseUserConsumerGroupPrivileges 
{
    public static Task<GetManagedDatabaseUserConsumerGroupPrivilegesResult> InvokeAsync(GetManagedDatabaseUserConsumerGroupPrivilegesArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseUserConsumerGroupPrivilegesResult> Invoke(GetManagedDatabaseUserConsumerGroupPrivilegesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetManagedDatabaseUserConsumerGroupPrivilegesResult> getManagedDatabaseUserConsumerGroupPrivileges(GetManagedDatabaseUserConsumerGroupPrivilegesArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseUserConsumerGroupPrivilegesResult> getManagedDatabaseUserConsumerGroupPrivileges(GetManagedDatabaseUserConsumerGroupPrivilegesArgs args, InvokeOptions options)

fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseUserConsumerGroupPrivileges:getManagedDatabaseUserConsumerGroupPrivileges
  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.
Filters List<GetManagedDatabaseUserConsumerGroupPrivilegesFilter>
Name string: A filter to return only resources that match the entire name.
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.
Filters []GetManagedDatabaseUserConsumerGroupPrivilegesFilter
Name string: A filter to return only resources that match the entire name.
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.
filters List<GetManagedDatabaseUserConsumerGroupPrivilegesFilter>
name String: A filter to return only resources that match the entire name.
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.
filters GetManagedDatabaseUserConsumerGroupPrivilegesFilter[]
name string: A filter to return only resources that match the entire name.
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.
filters Sequence[databasemanagement.GetManagedDatabaseUserConsumerGroupPrivilegesFilter]
name str: A filter to return only resources that match the entire name.
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.
filters List<Property Map>
name String: A filter to return only resources that match the entire name.
opcNamedCredentialId String: The OCID of the Named Credential.

getManagedDatabaseUserConsumerGroupPrivileges Result

The following output properties are available:

ConsumerGroupPrivilegeCollections List<GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollection>: The list of consumer_group_privilege_collection.
Id string: The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
UserName string
Filters List<GetManagedDatabaseUserConsumerGroupPrivilegesFilter>
Name string: The name of the granted consumer group privilege.
OpcNamedCredentialId string

ConsumerGroupPrivilegeCollections []GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollection: The list of consumer_group_privilege_collection.
Id string: The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
UserName string
Filters []GetManagedDatabaseUserConsumerGroupPrivilegesFilter
Name string: The name of the granted consumer group privilege.
OpcNamedCredentialId string

consumerGroupPrivilegeCollections List<GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollection>: The list of consumer_group_privilege_collection.
id String: The provider-assigned unique ID for this managed resource.
managedDatabaseId String
userName String
filters List<GetManagedDatabaseUserConsumerGroupPrivilegesFilter>
name String: The name of the granted consumer group privilege.
opcNamedCredentialId String

consumerGroupPrivilegeCollections GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollection[]: The list of consumer_group_privilege_collection.
id string: The provider-assigned unique ID for this managed resource.
managedDatabaseId string
userName string
filters GetManagedDatabaseUserConsumerGroupPrivilegesFilter[]
name string: The name of the granted consumer group privilege.
opcNamedCredentialId string

consumer_group_privilege_collections Sequence[databasemanagement.GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollection]: The list of consumer_group_privilege_collection.
id str: The provider-assigned unique ID for this managed resource.
managed_database_id str
user_name str
filters Sequence[databasemanagement.GetManagedDatabaseUserConsumerGroupPrivilegesFilter]
name str: The name of the granted consumer group privilege.
opc_named_credential_id str

consumerGroupPrivilegeCollections List<Property Map>: The list of consumer_group_privilege_collection.
id String: The provider-assigned unique ID for this managed resource.
managedDatabaseId String
userName String
filters List<Property Map>
name String: The name of the granted consumer group privilege.
opcNamedCredentialId String

Supporting Types

GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollection

Items List<GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem>: An array of consumer group privileges.

Items []GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem: An array of consumer group privileges.

items List<GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem>: An array of consumer group privileges.

items GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem[]: An array of consumer group privileges.

items Sequence[databasemanagement.GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem]: An array of consumer group privileges.

items List<Property Map>: An array of consumer group privileges.

GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem

GrantOption string: Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
InitialGroup string: Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
Name string: A filter to return only resources that match the entire name.

GrantOption string: Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
InitialGroup string: Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
Name string: A filter to return only resources that match the entire name.

grantOption String: Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
initialGroup String: Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
name String: A filter to return only resources that match the entire name.

grantOption string: Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
initialGroup string: Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
name string: A filter to return only resources that match the entire name.

grant_option str: Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
initial_group str: Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
name str: A filter to return only resources that match the entire name.

grantOption String: Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
initialGroup String: Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
name String: A filter to return only resources that match the entire name.

GetManagedDatabaseUserConsumerGroupPrivilegesFilter

Name string: A filter to return only resources that match the entire name.
Values List<string>
Regex bool

Name string: A filter to return only resources that match the entire name.
Values []string
Regex bool

name String: A filter to return only resources that match the entire name.
values List<String>
regex Boolean

name string: A filter to return only resources that match the entire name.
values string[]
regex boolean

name str: A filter to return only resources that match the entire name.
values Sequence[str]
regex bool

name String: A filter to return only resources that match the entire name.
values List<String>
regex Boolean

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.27.0 published on Thursday, Mar 20, 2025 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseUserConsumerGroupPrivileges

On this page

On this page

Example Usage

Using getManagedDatabaseUserConsumerGroupPrivileges

getManagedDatabaseUserConsumerGroupPrivileges Result

Supporting Types

GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollection

GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem

GetManagedDatabaseUserConsumerGroupPrivilegesFilter

Package Details

On this page

On this page