Oracle Cloud Infrastructure
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 Pulumi;
using Oci = Pulumi.Oci;
class MyStack : Stack
{
public MyStack()
{
var testManagedDatabasesUserSystemPrivileges = Output.Create(Oci.DatabaseManagement.GetManagedDatabasesUserSystemPrivileges.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabasesUserSystemPrivilegesArgs
{
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
})
}
Coming soon!
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,
});
Coming soon!
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
- https://github.com/pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
oci
Terraform Provider.