1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabasesUserSystemPrivileges
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabasesUserSystemPrivileges

Explore with Pulumi AI

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

Gets the list of system privileges granted to a specific user.

Example Usage

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

const testManagedDatabasesUserSystemPrivileges = oci.DatabaseManagement.getManagedDatabasesUserSystemPrivileges({
    managedDatabaseId: testManagedDatabase.id,
    userName: testUser.name,
    name: managedDatabasesUserSystemPrivilegeName,
    opcNamedCredentialId: managedDatabasesUserSystemPrivilegeOpcNamedCredentialId,
});
Copy
import pulumi
import pulumi_oci as oci

test_managed_databases_user_system_privileges = oci.DatabaseManagement.get_managed_databases_user_system_privileges(managed_database_id=test_managed_database["id"],
    user_name=test_user["name"],
    name=managed_databases_user_system_privilege_name,
    opc_named_credential_id=managed_databases_user_system_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.GetManagedDatabasesUserSystemPrivileges(ctx, &databasemanagement.GetManagedDatabasesUserSystemPrivilegesArgs{
			ManagedDatabaseId:    testManagedDatabase.Id,
			UserName:             testUser.Name,
			Name:                 pulumi.StringRef(managedDatabasesUserSystemPrivilegeName),
			OpcNamedCredentialId: pulumi.StringRef(managedDatabasesUserSystemPrivilegeOpcNamedCredentialId),
		}, 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 testManagedDatabasesUserSystemPrivileges = Oci.DatabaseManagement.GetManagedDatabasesUserSystemPrivileges.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        UserName = testUser.Name,
        Name = managedDatabasesUserSystemPrivilegeName,
        OpcNamedCredentialId = managedDatabasesUserSystemPrivilegeOpcNamedCredentialId,
    });

});
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.GetManagedDatabasesUserSystemPrivilegesArgs;
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 testManagedDatabasesUserSystemPrivileges = DatabaseManagementFunctions.getManagedDatabasesUserSystemPrivileges(GetManagedDatabasesUserSystemPrivilegesArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .userName(testUser.name())
            .name(managedDatabasesUserSystemPrivilegeName)
            .opcNamedCredentialId(managedDatabasesUserSystemPrivilegeOpcNamedCredentialId)
            .build());

    }
}
Copy
variables:
  testManagedDatabasesUserSystemPrivileges:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabasesUserSystemPrivileges
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        userName: ${testUser.name}
        name: ${managedDatabasesUserSystemPrivilegeName}
        opcNamedCredentialId: ${managedDatabasesUserSystemPrivilegeOpcNamedCredentialId}
Copy

Using getManagedDatabasesUserSystemPrivileges

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 getManagedDatabasesUserSystemPrivileges(args: GetManagedDatabasesUserSystemPrivilegesArgs, opts?: InvokeOptions): Promise<GetManagedDatabasesUserSystemPrivilegesResult>
function getManagedDatabasesUserSystemPrivilegesOutput(args: GetManagedDatabasesUserSystemPrivilegesOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabasesUserSystemPrivilegesResult>
Copy
def get_managed_databases_user_system_privileges(filters: Optional[Sequence[_databasemanagement.GetManagedDatabasesUserSystemPrivilegesFilter]] = 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) -> GetManagedDatabasesUserSystemPrivilegesResult
def get_managed_databases_user_system_privileges_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabasesUserSystemPrivilegesFilterArgs]]]] = 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[GetManagedDatabasesUserSystemPrivilegesResult]
Copy
func GetManagedDatabasesUserSystemPrivileges(ctx *Context, args *GetManagedDatabasesUserSystemPrivilegesArgs, opts ...InvokeOption) (*GetManagedDatabasesUserSystemPrivilegesResult, error)
func GetManagedDatabasesUserSystemPrivilegesOutput(ctx *Context, args *GetManagedDatabasesUserSystemPrivilegesOutputArgs, opts ...InvokeOption) GetManagedDatabasesUserSystemPrivilegesResultOutput
Copy

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

public static class GetManagedDatabasesUserSystemPrivileges 
{
    public static Task<GetManagedDatabasesUserSystemPrivilegesResult> InvokeAsync(GetManagedDatabasesUserSystemPrivilegesArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabasesUserSystemPrivilegesResult> Invoke(GetManagedDatabasesUserSystemPrivilegesInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetManagedDatabasesUserSystemPrivilegesResult> getManagedDatabasesUserSystemPrivileges(GetManagedDatabasesUserSystemPrivilegesArgs args, InvokeOptions options)
public static Output<GetManagedDatabasesUserSystemPrivilegesResult> getManagedDatabasesUserSystemPrivileges(GetManagedDatabasesUserSystemPrivilegesArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabasesUserSystemPrivileges:getManagedDatabasesUserSystemPrivileges
  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<GetManagedDatabasesUserSystemPrivilegesFilter>
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. []GetManagedDatabasesUserSystemPrivilegesFilter
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<GetManagedDatabasesUserSystemPrivilegesFilter>
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. GetManagedDatabasesUserSystemPrivilegesFilter[]
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.GetManagedDatabasesUserSystemPrivilegesFilter]
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.

getManagedDatabasesUserSystemPrivileges Result

The following output properties are available:

Id string
The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
SystemPrivilegeCollections List<GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollection>
The list of system_privilege_collection.
UserName string
Filters List<GetManagedDatabasesUserSystemPrivilegesFilter>
Name string
The name of a system privilege.
OpcNamedCredentialId string
Id string
The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
SystemPrivilegeCollections []GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollection
The list of system_privilege_collection.
UserName string
Filters []GetManagedDatabasesUserSystemPrivilegesFilter
Name string
The name of a system privilege.
OpcNamedCredentialId string
id String
The provider-assigned unique ID for this managed resource.
managedDatabaseId String
systemPrivilegeCollections List<GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollection>
The list of system_privilege_collection.
userName String
filters List<GetManagedDatabasesUserSystemPrivilegesFilter>
name String
The name of a system privilege.
opcNamedCredentialId String
id string
The provider-assigned unique ID for this managed resource.
managedDatabaseId string
systemPrivilegeCollections GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollection[]
The list of system_privilege_collection.
userName string
filters GetManagedDatabasesUserSystemPrivilegesFilter[]
name string
The name of a system privilege.
opcNamedCredentialId string
id String
The provider-assigned unique ID for this managed resource.
managedDatabaseId String
systemPrivilegeCollections List<Property Map>
The list of system_privilege_collection.
userName String
filters List<Property Map>
name String
The name of a system privilege.
opcNamedCredentialId String

Supporting Types

GetManagedDatabasesUserSystemPrivilegesFilter

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

GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollection

Items This property is required. List<GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollectionItem>
An array of system privileges.
Items This property is required. []GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollectionItem
An array of system privileges.
items This property is required. List<GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollectionItem>
An array of system privileges.
items This property is required. GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollectionItem[]
An array of system privileges.
items This property is required. List<Property Map>
An array of system privileges.

GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollectionItem

AdminOption This property is required. string
Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
Common This property is required. 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 This property is required. string
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
Name This property is required. string
A filter to return only resources that match the entire name.
AdminOption This property is required. string
Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
Common This property is required. 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 This property is required. string
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
Name This property is required. string
A filter to return only resources that match the entire name.
adminOption This property is required. String
Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
common This property is required. 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 This property is required. String
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
name This property is required. String
A filter to return only resources that match the entire name.
adminOption This property is required. string
Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
common This property is required. 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 This property is required. string
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
name This property is required. string
A filter to return only resources that match the entire name.
admin_option This property is required. str
Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
common This property is required. 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 This property is required. str
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
name This property is required. str
A filter to return only resources that match the entire name.
adminOption This property is required. String
Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
common This property is required. 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 This property is required. String
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
name This property is required. 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.