oci.DatabaseManagement.getManagedDatabasesUserSystemPrivileges
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
using System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var testManagedDatabasesUserSystemPrivileges = Oci.DatabaseManagement.GetManagedDatabasesUserSystemPrivileges.Invoke(new()
{
ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
UserName = oci_identity_user.Test_user.Name,
Name = @var.Managed_databases_user_system_privilege_name,
});
});
package main
import (
"github.com/pulumi/pulumi-oci/sdk/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: oci_database_management_managed_database.Test_managed_database.Id,
UserName: oci_identity_user.Test_user.Name,
Name: pulumi.StringRef(_var.Managed_databases_user_system_privilege_name),
}, nil)
if err != nil {
return err
}
return nil
})
}
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(oci_database_management_managed_database.test_managed_database().id())
.userName(oci_identity_user.test_user().name())
.name(var_.managed_databases_user_system_privilege_name())
.build());
}
}
import pulumi
import pulumi_oci as oci
test_managed_databases_user_system_privileges = oci.DatabaseManagement.get_managed_databases_user_system_privileges(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
user_name=oci_identity_user["test_user"]["name"],
name=var["managed_databases_user_system_privilege_name"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testManagedDatabasesUserSystemPrivileges = oci.DatabaseManagement.getManagedDatabasesUserSystemPrivileges({
managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
userName: oci_identity_user.test_user.name,
name: _var.managed_databases_user_system_privilege_name,
});
variables:
testManagedDatabasesUserSystemPrivileges:
fn::invoke:
Function: oci:DatabaseManagement:getManagedDatabasesUserSystemPrivileges
Arguments:
managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
userName: ${oci_identity_user.test_user.name}
name: ${var.managed_databases_user_system_privilege_name}
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,
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,
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)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:DatabaseManagement/getManagedDatabasesUserSystemPrivileges:getManagedDatabasesUserSystemPrivileges
arguments:
# arguments dictionary
The 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.
- Filters
List<Get
Managed Databases User System Privileges Filter> - 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.
- Filters
[]Get
Managed Databases User System Privileges Filter - 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.
- filters
List<Get
Managed Databases User System Privileges Filter> - 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.
- filters
Get
Managed Databases User System Privileges Filter[] - 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.
- filters
Get
Managed Databases User System Privileges Filter] - 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.
- filters List<Property Map>
- name String
A filter to return only resources that match the entire name.
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.
- 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.
- 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.
- 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.
- id str
The provider-assigned unique ID for this managed resource.
- managed_
database_ strid - system_
privilege_ Getcollections Managed Databases User System Privileges System Privilege Collection] The list of system_privilege_collection.
- user_
name str - filters
Get
Managed Databases User System Privileges Filter] - name str
The name of a system privilege.
- 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.
Supporting Types
GetManagedDatabasesUserSystemPrivilegesFilter
GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollection
- Items
List<Get
Managed Databases User System Privileges System Privilege Collection Item> An array of system privileges.
- Items
[]Get
Managed Databases User System Privileges System Privilege Collection Item An array of system privileges.
- items
List<Get
Managed Databases User System Privileges System Privilege Collection Item> An array of system privileges.
- items
Get
Managed Databases User System Privileges System Privilege Collection Item[] An array of system privileges.
- items
Get
Managed Databases User System Privileges System Privilege Collection Item] An array of system privileges.
- items List<Property Map>
An array of system privileges.
GetManagedDatabasesUserSystemPrivilegesSystemPrivilegeCollectionItem
- Admin
Option string Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
- Common 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 string
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
- Name string
A filter to return only resources that match the entire name.
- Admin
Option string Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
- Common 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 string
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
- Name string
A filter to return only resources that match the entire name.
- admin
Option String Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
- common 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 String
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
- name String
A filter to return only resources that match the entire name.
- admin
Option string Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
- common 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 string
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
- name string
A filter to return only resources that match the entire name.
- admin_
option str Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
- common 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 str
Indicates whether the granted system privilege is inherited from another container (YES) or not (NO).
- name str
A filter to return only resources that match the entire name.
- admin
Option String Indicates whether the system privilege is granted with the ADMIN option (YES) or not (NO).
- common 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 String
Indicates whether the granted system privilege is inherited from another container (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
oci
Terraform Provider.