Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
oci.DatabaseManagement.getManagedDatabaseUserConsumerGroupPrivilege
Explore with Pulumi AI
This data source provides details about a specific Managed Database User Consumer Group Privilege resource 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 testManagedDatabaseUserConsumerGroupPrivilege = oci.DatabaseManagement.getManagedDatabaseUserConsumerGroupPrivilege({
    managedDatabaseId: testManagedDatabase.id,
    userName: testUser.name,
    name: managedDatabaseUserConsumerGroupPrivilegeName,
});
import pulumi
import pulumi_oci as oci
test_managed_database_user_consumer_group_privilege = oci.DatabaseManagement.get_managed_database_user_consumer_group_privilege(managed_database_id=test_managed_database["id"],
    user_name=test_user["name"],
    name=managed_database_user_consumer_group_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.GetManagedDatabaseUserConsumerGroupPrivilege(ctx, &databasemanagement.GetManagedDatabaseUserConsumerGroupPrivilegeArgs{
			ManagedDatabaseId: testManagedDatabase.Id,
			UserName:          testUser.Name,
			Name:              pulumi.StringRef(managedDatabaseUserConsumerGroupPrivilegeName),
		}, 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 testManagedDatabaseUserConsumerGroupPrivilege = Oci.DatabaseManagement.GetManagedDatabaseUserConsumerGroupPrivilege.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        UserName = testUser.Name,
        Name = managedDatabaseUserConsumerGroupPrivilegeName,
    });
});
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.GetManagedDatabaseUserConsumerGroupPrivilegeArgs;
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 testManagedDatabaseUserConsumerGroupPrivilege = DatabaseManagementFunctions.getManagedDatabaseUserConsumerGroupPrivilege(GetManagedDatabaseUserConsumerGroupPrivilegeArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .userName(testUser.name())
            .name(managedDatabaseUserConsumerGroupPrivilegeName)
            .build());
    }
}
variables:
  testManagedDatabaseUserConsumerGroupPrivilege:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseUserConsumerGroupPrivilege
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        userName: ${testUser.name}
        name: ${managedDatabaseUserConsumerGroupPrivilegeName}
Using getManagedDatabaseUserConsumerGroupPrivilege
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 getManagedDatabaseUserConsumerGroupPrivilege(args: GetManagedDatabaseUserConsumerGroupPrivilegeArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseUserConsumerGroupPrivilegeResult>
function getManagedDatabaseUserConsumerGroupPrivilegeOutput(args: GetManagedDatabaseUserConsumerGroupPrivilegeOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseUserConsumerGroupPrivilegeResult>def get_managed_database_user_consumer_group_privilege(managed_database_id: Optional[str] = None,
                                                       name: Optional[str] = None,
                                                       user_name: Optional[str] = None,
                                                       opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseUserConsumerGroupPrivilegeResult
def get_managed_database_user_consumer_group_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[GetManagedDatabaseUserConsumerGroupPrivilegeResult]func GetManagedDatabaseUserConsumerGroupPrivilege(ctx *Context, args *GetManagedDatabaseUserConsumerGroupPrivilegeArgs, opts ...InvokeOption) (*GetManagedDatabaseUserConsumerGroupPrivilegeResult, error)
func GetManagedDatabaseUserConsumerGroupPrivilegeOutput(ctx *Context, args *GetManagedDatabaseUserConsumerGroupPrivilegeOutputArgs, opts ...InvokeOption) GetManagedDatabaseUserConsumerGroupPrivilegeResultOutput> Note: This function is named GetManagedDatabaseUserConsumerGroupPrivilege in the Go SDK.
public static class GetManagedDatabaseUserConsumerGroupPrivilege 
{
    public static Task<GetManagedDatabaseUserConsumerGroupPrivilegeResult> InvokeAsync(GetManagedDatabaseUserConsumerGroupPrivilegeArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseUserConsumerGroupPrivilegeResult> Invoke(GetManagedDatabaseUserConsumerGroupPrivilegeInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetManagedDatabaseUserConsumerGroupPrivilegeResult> getManagedDatabaseUserConsumerGroupPrivilege(GetManagedDatabaseUserConsumerGroupPrivilegeArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseUserConsumerGroupPrivilegeResult> getManagedDatabaseUserConsumerGroupPrivilege(GetManagedDatabaseUserConsumerGroupPrivilegeArgs args, InvokeOptions options)
fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseUserConsumerGroupPrivilege:getManagedDatabaseUserConsumerGroupPrivilege
  arguments:
    # arguments dictionaryThe following arguments are supported:
- ManagedDatabase stringId 
- 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.
- ManagedDatabase stringId 
- 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.
- managedDatabase StringId 
- 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.
- managedDatabase stringId 
- 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_ strid 
- 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.
- managedDatabase StringId 
- 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.
getManagedDatabaseUserConsumerGroupPrivilege Result
The following output properties are available:
- Id string
- The provider-assigned unique ID for this managed resource.
- Items
List<GetManaged Database User Consumer Group Privilege Item> 
- An array of consumer group privileges.
- ManagedDatabase stringId 
- UserName string
- Name string
- The name of the granted consumer group privilege.
- Id string
- The provider-assigned unique ID for this managed resource.
- Items
[]GetManaged Database User Consumer Group Privilege Item 
- An array of consumer group privileges.
- ManagedDatabase stringId 
- UserName string
- Name string
- The name of the granted consumer group privilege.
- id String
- The provider-assigned unique ID for this managed resource.
- items
List<GetManaged Database User Consumer Group Privilege Item> 
- An array of consumer group privileges.
- managedDatabase StringId 
- userName String
- name String
- The name of the granted consumer group privilege.
- id string
- The provider-assigned unique ID for this managed resource.
- items
GetManaged Database User Consumer Group Privilege Item[] 
- An array of consumer group privileges.
- managedDatabase stringId 
- userName string
- name string
- The name of the granted consumer group privilege.
- id str
- The provider-assigned unique ID for this managed resource.
- items
Sequence[databasemanagement.Get Managed Database User Consumer Group Privilege Item] 
- An array of consumer group privileges.
- managed_database_ strid 
- user_name str
- name str
- The name of the granted consumer group privilege.
- id String
- The provider-assigned unique ID for this managed resource.
- items List<Property Map>
- An array of consumer group privileges.
- managedDatabase StringId 
- userName String
- name String
- The name of the granted consumer group privilege.
Supporting Types
GetManagedDatabaseUserConsumerGroupPrivilegeItem       
- 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.
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the ociTerraform Provider.