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:
- Managed
Database stringId  - The OCID of the Managed Database.
 - User
Name 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 stringId  - The OCID of the Managed Database.
 - User
Name 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 StringId  - The OCID of the Managed Database.
 - user
Name 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 stringId  - The OCID of the Managed Database.
 - user
Name 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.
 
- managed
Database StringId  - The OCID of the Managed Database.
 - user
Name 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<Get
Managed Database User Consumer Group Privilege Item>  - An array of consumer group privileges.
 - Managed
Database stringId  - User
Name string - Name string
 - The name of the granted consumer group privilege.
 
- Id string
 - The provider-assigned unique ID for this managed resource.
 - Items
[]Get
Managed Database User Consumer Group Privilege Item  - An array of consumer group privileges.
 - Managed
Database stringId  - User
Name string - Name string
 - The name of the granted consumer group privilege.
 
- id String
 - The provider-assigned unique ID for this managed resource.
 - items
List<Get
Managed Database User Consumer Group Privilege Item>  - An array of consumer group privileges.
 - managed
Database StringId  - user
Name String - name String
 - The name of the granted consumer group privilege.
 
- id string
 - The provider-assigned unique ID for this managed resource.
 - items
Get
Managed Database User Consumer Group Privilege Item[]  - An array of consumer group privileges.
 - managed
Database stringId  - user
Name 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.
 - managed
Database StringId  - user
Name String - name String
 - The name of the granted consumer group privilege.
 
Supporting Types
GetManagedDatabaseUserConsumerGroupPrivilegeItem       
- Grant
Option string - Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
 - Initial
Group 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 string - Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
 - Initial
Group 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 String - Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
 - initial
Group 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 string - Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
 - initial
Group 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.
 
- grant
Option String - Indicates whether the privilege is granted with the GRANT option (YES) or not (NO).
 - initial
Group 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.