1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseUserConsumerGroupPrivileges
Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabaseUserConsumerGroupPrivileges

Explore with Pulumi AI

This data source provides the list of Managed Database User Consumer Group Privileges in Oracle Cloud Infrastructure Database Management service.

Gets the list of consumer group privileges granted to a specific user.

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,
});
Copy
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)
Copy
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
	})
}
Copy
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,
    });

});
Copy
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());

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

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>
Copy
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]
Copy
func GetManagedDatabaseUserConsumerGroupPrivileges(ctx *Context, args *GetManagedDatabaseUserConsumerGroupPrivilegesArgs, opts ...InvokeOption) (*GetManagedDatabaseUserConsumerGroupPrivilegesResult, error)
func GetManagedDatabaseUserConsumerGroupPrivilegesOutput(ctx *Context, args *GetManagedDatabaseUserConsumerGroupPrivilegesOutputArgs, opts ...InvokeOption) GetManagedDatabaseUserConsumerGroupPrivilegesResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetManagedDatabaseUserConsumerGroupPrivilegesResult> getManagedDatabaseUserConsumerGroupPrivileges(GetManagedDatabaseUserConsumerGroupPrivilegesArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseUserConsumerGroupPrivilegesResult> getManagedDatabaseUserConsumerGroupPrivileges(GetManagedDatabaseUserConsumerGroupPrivilegesArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseUserConsumerGroupPrivileges:getManagedDatabaseUserConsumerGroupPrivileges
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

ManagedDatabaseId This property is required. string
The OCID of the Managed Database.
UserName This property is required. string
The name of the user whose details are to be viewed.
Filters Changes to this property will trigger replacement. List<GetManagedDatabaseUserConsumerGroupPrivilegesFilter>
Name string
A filter to return only resources that match the entire name.
OpcNamedCredentialId string
The OCID of the Named Credential.
ManagedDatabaseId This property is required. string
The OCID of the Managed Database.
UserName This property is required. string
The name of the user whose details are to be viewed.
Filters Changes to this property will trigger replacement. []GetManagedDatabaseUserConsumerGroupPrivilegesFilter
Name string
A filter to return only resources that match the entire name.
OpcNamedCredentialId string
The OCID of the Named Credential.
managedDatabaseId This property is required. String
The OCID of the Managed Database.
userName This property is required. String
The name of the user whose details are to be viewed.
filters Changes to this property will trigger replacement. List<GetManagedDatabaseUserConsumerGroupPrivilegesFilter>
name String
A filter to return only resources that match the entire name.
opcNamedCredentialId String
The OCID of the Named Credential.
managedDatabaseId This property is required. string
The OCID of the Managed Database.
userName This property is required. string
The name of the user whose details are to be viewed.
filters Changes to this property will trigger replacement. 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 This property is required. str
The OCID of the Managed Database.
user_name This property is required. str
The name of the user whose details are to be viewed.
filters Changes to this property will trigger replacement. 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 This property is required. String
The OCID of the Managed Database.
userName This property is required. String
The name of the user whose details are to be viewed.
filters Changes to this property will trigger replacement. 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
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 This property is required. List<GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem>
An array of consumer group privileges.
Items This property is required. []GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem
An array of consumer group privileges.
items This property is required. List<GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem>
An array of consumer group privileges.
items This property is required. GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem[]
An array of consumer group privileges.
items This property is required. List<Property Map>
An array of consumer group privileges.

GetManagedDatabaseUserConsumerGroupPrivilegesConsumerGroupPrivilegeCollectionItem

GrantOption This property is required. string
Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
InitialGroup This property is required. string
Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
Name This property is required. string
A filter to return only resources that match the entire name.
GrantOption This property is required. string
Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
InitialGroup This property is required. string
Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
Name This property is required. string
A filter to return only resources that match the entire name.
grantOption This property is required. String
Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
initialGroup This property is required. String
Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
name This property is required. String
A filter to return only resources that match the entire name.
grantOption This property is required. string
Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
initialGroup This property is required. string
Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
name This property is required. string
A filter to return only resources that match the entire name.
grant_option This property is required. str
Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
initial_group This property is required. str
Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
name This property is required. str
A filter to return only resources that match the entire name.
grantOption This property is required. String
Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
initialGroup This property is required. String
Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO).
name This property is required. String
A filter to return only resources that match the entire name.

GetManagedDatabaseUserConsumerGroupPrivilegesFilter

Name This property is required. string
A filter to return only resources that match the entire name.
Values This property is required. List<string>
Regex bool
Name This property is required. string
A filter to return only resources that match the entire name.
Values This property is required. []string
Regex bool
name This property is required. String
A filter to return only resources that match the entire name.
values This property is required. List<String>
regex Boolean
name This property is required. string
A filter to return only resources that match the entire name.
values This property is required. string[]
regex boolean
name This property is required. str
A filter to return only resources that match the entire name.
values This property is required. Sequence[str]
regex bool
name This property is required. String
A filter to return only resources that match the entire name.
values This property is required. 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.