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,
});
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)
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
})
}
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,
});
});
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());
}
}
variables:
testManagedDatabasesUserSystemPrivileges:
fn::invoke:
function: oci:DatabaseManagement:getManagedDatabasesUserSystemPrivileges
arguments:
managedDatabaseId: ${testManagedDatabase.id}
userName: ${testUser.name}
name: ${managedDatabasesUserSystemPrivilegeName}
opcNamedCredentialId: ${managedDatabasesUserSystemPrivilegeOpcNamedCredentialId}
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>
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]
func GetManagedDatabasesUserSystemPrivileges(ctx *Context, args *GetManagedDatabasesUserSystemPrivilegesArgs, opts ...InvokeOption) (*GetManagedDatabasesUserSystemPrivilegesResult, error)
func GetManagedDatabasesUserSystemPrivilegesOutput(ctx *Context, args *GetManagedDatabasesUserSystemPrivilegesOutputArgs, opts ...InvokeOption) GetManagedDatabasesUserSystemPrivilegesResultOutput
> 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)
}
public static CompletableFuture<GetManagedDatabasesUserSystemPrivilegesResult> getManagedDatabasesUserSystemPrivileges(GetManagedDatabasesUserSystemPrivilegesArgs args, InvokeOptions options)
public static Output<GetManagedDatabasesUserSystemPrivilegesResult> getManagedDatabasesUserSystemPrivileges(GetManagedDatabasesUserSystemPrivilegesArgs args, InvokeOptions options)
fn::invoke:
function: oci:DatabaseManagement/getManagedDatabasesUserSystemPrivileges:getManagedDatabasesUserSystemPrivileges
arguments:
# arguments dictionary
The following arguments are supported:
- Managed
Database Id This property is required. string - The OCID of the Managed Database.
- User
Name This property is required. string - The name of the user whose details are to be viewed.
- Filters
Changes to this property will trigger replacement.
Managed Databases User System Privileges Filter> - Name string
- A filter to return only resources that match the entire name.
- Opc
Named stringCredential Id - The OCID of the Named Credential.
- Managed
Database Id This property is required. string - The OCID of the Managed Database.
- User
Name This property is required. string - The name of the user whose details are to be viewed.
- Filters
Changes to this property will trigger replacement.
Managed Databases User System Privileges Filter - Name string
- A filter to return only resources that match the entire name.
- Opc
Named stringCredential Id - The OCID of the Named Credential.
- managed
Database Id This property is required. String - The OCID of the Managed Database.
- user
Name This property is required. String - The name of the user whose details are to be viewed.
- filters
Changes to this property will trigger replacement.
Managed Databases User System Privileges Filter> - name String
- A filter to return only resources that match the entire name.
- opc
Named StringCredential Id - The OCID of the Named Credential.
- managed
Database Id This property is required. string - The OCID of the Managed Database.
- user
Name This property is required. string - The name of the user whose details are to be viewed.
- filters
Changes to this property will trigger replacement.
Managed Databases User System Privileges Filter[] - name string
- A filter to return only resources that match the entire name.
- opc
Named stringCredential Id - 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.
Get Managed Databases User System Privileges Filter] - name str
- A filter to return only resources that match the entire name.
- opc_
named_ strcredential_ id - The OCID of the Named Credential.
- managed
Database Id This property is required. String - The OCID of the Managed Database.
- user
Name This property is required. String - The name of the user whose details are to be viewed.
- filters
Changes to this property will trigger replacement.
- name String
- A filter to return only resources that match the entire name.
- opc
Named StringCredential Id - 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.
- Managed
Database stringId - System
Privilege List<GetCollections Managed Databases User System Privileges System Privilege Collection> - The list of system_privilege_collection.
- User
Name string - Filters
List<Get
Managed Databases User System Privileges Filter> - Name string
- The name of a system privilege.
- Opc
Named stringCredential Id
- Id string
- The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - System
Privilege []GetCollections Managed Databases User System Privileges System Privilege Collection - The list of system_privilege_collection.
- User
Name string - Filters
[]Get
Managed Databases User System Privileges Filter - Name string
- The name of a system privilege.
- Opc
Named stringCredential Id
- id String
- The provider-assigned unique ID for this managed resource.
- managed
Database StringId - system
Privilege List<GetCollections Managed Databases User System Privileges System Privilege Collection> - The list of system_privilege_collection.
- user
Name String - filters
List<Get
Managed Databases User System Privileges Filter> - name String
- The name of a system privilege.
- opc
Named StringCredential Id
- id string
- The provider-assigned unique ID for this managed resource.
- managed
Database stringId - system
Privilege GetCollections Managed Databases User System Privileges System Privilege Collection[] - The list of system_privilege_collection.
- user
Name string - filters
Get
Managed Databases User System Privileges Filter[] - name string
- The name of a system privilege.
- opc
Named stringCredential Id
- id str
- The provider-assigned unique ID for this managed resource.
- managed_
database_ strid - system_
privilege_ Sequence[databasemanagement.collections Get Managed Databases User System Privileges System Privilege Collection] - The list of system_privilege_collection.
- user_
name str - filters
Sequence[databasemanagement.
Get Managed Databases User System Privileges Filter] - name str
- The name of a system privilege.
- opc_
named_ strcredential_ id
- id String
- The provider-assigned unique ID for this managed resource.
- managed
Database StringId - system
Privilege List<Property Map>Collections - The list of system_privilege_collection.
- user
Name String - filters List<Property Map>
- name String
- The name of a system privilege.
- opc
Named StringCredential Id
Supporting Types
GetManagedDatabasesUserSystemPrivilegesFilter
GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollection
- Items
This property is required. List<GetManaged Databases User System Privileges System Privilege Collection Item> - An array of system privileges.
- Items
This property is required. []GetManaged Databases User System Privileges System Privilege Collection Item - An array of system privileges.
- items
This property is required. List<GetManaged Databases User System Privileges System Privilege Collection Item> - An array of system privileges.
- items
This property is required. GetManaged Databases User System Privileges System Privilege Collection Item[] - An array of system privileges.
- items
This property is required. Sequence[databasemanagement.Get Managed Databases User System Privileges System Privilege Collection Item] - An array of system privileges.
- items
This property is required. List<Property Map> - An array of system privileges.
GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollectionItem
- Admin
Option 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. 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. 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. 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.
- admin
Option 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.