Oracle Cloud Infrastructure v1.11.0, Sep 27 23

Oracle Cloud Infrastructure v1.11.0 published on Wednesday, Sep 27, 2023 by Pulumi

oci.DatabaseManagement.getManagedDatabaseUserObjectPrivilege

Explore with Pulumi AI

Oracle Cloud Infrastructure v1.11.0 published on Wednesday, Sep 27, 2023 by Pulumi

Example Usage

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseUserObjectPrivilege = Oci.DatabaseManagement.GetManagedDatabaseUserObjectPrivilege.Invoke(new()
    {
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
        UserName = oci_identity_user.Test_user.Name,
        Name = @var.Managed_database_user_object_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.GetManagedDatabaseUserObjectPrivilege(ctx, &databasemanagement.GetManagedDatabaseUserObjectPrivilegeArgs{
			ManagedDatabaseId: oci_database_management_managed_database.Test_managed_database.Id,
			UserName:          oci_identity_user.Test_user.Name,
			Name:              pulumi.StringRef(_var.Managed_database_user_object_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.GetManagedDatabaseUserObjectPrivilegeArgs;
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 testManagedDatabaseUserObjectPrivilege = DatabaseManagementFunctions.getManagedDatabaseUserObjectPrivilege(GetManagedDatabaseUserObjectPrivilegeArgs.builder()
            .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
            .userName(oci_identity_user.test_user().name())
            .name(var_.managed_database_user_object_privilege_name())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_managed_database_user_object_privilege = oci.DatabaseManagement.get_managed_database_user_object_privilege(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
    user_name=oci_identity_user["test_user"]["name"],
    name=var["managed_database_user_object_privilege_name"])

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

const testManagedDatabaseUserObjectPrivilege = oci.DatabaseManagement.getManagedDatabaseUserObjectPrivilege({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    userName: oci_identity_user.test_user.name,
    name: _var.managed_database_user_object_privilege_name,
});

variables:
  testManagedDatabaseUserObjectPrivilege:
    fn::invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseUserObjectPrivilege
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        userName: ${oci_identity_user.test_user.name}
        name: ${var.managed_database_user_object_privilege_name}

Using getManagedDatabaseUserObjectPrivilege

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 getManagedDatabaseUserObjectPrivilege(args: GetManagedDatabaseUserObjectPrivilegeArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseUserObjectPrivilegeResult>
function getManagedDatabaseUserObjectPrivilegeOutput(args: GetManagedDatabaseUserObjectPrivilegeOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseUserObjectPrivilegeResult>

def get_managed_database_user_object_privilege(managed_database_id: Optional[str] = None,
                                               name: Optional[str] = None,
                                               user_name: Optional[str] = None,
                                               opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseUserObjectPrivilegeResult
def get_managed_database_user_object_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[GetManagedDatabaseUserObjectPrivilegeResult]

func GetManagedDatabaseUserObjectPrivilege(ctx *Context, args *GetManagedDatabaseUserObjectPrivilegeArgs, opts ...InvokeOption) (*GetManagedDatabaseUserObjectPrivilegeResult, error)
func GetManagedDatabaseUserObjectPrivilegeOutput(ctx *Context, args *GetManagedDatabaseUserObjectPrivilegeOutputArgs, opts ...InvokeOption) GetManagedDatabaseUserObjectPrivilegeResultOutput

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

public static class GetManagedDatabaseUserObjectPrivilege 
{
    public static Task<GetManagedDatabaseUserObjectPrivilegeResult> InvokeAsync(GetManagedDatabaseUserObjectPrivilegeArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseUserObjectPrivilegeResult> Invoke(GetManagedDatabaseUserObjectPrivilegeInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetManagedDatabaseUserObjectPrivilegeResult> getManagedDatabaseUserObjectPrivilege(GetManagedDatabaseUserObjectPrivilegeArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseUserObjectPrivilege:getManagedDatabaseUserObjectPrivilege
  arguments:
    # arguments dictionary

The following arguments are supported:

ManagedDatabaseId string: The OCID of the Managed Database.
UserName 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.

ManagedDatabaseId string: The OCID of the Managed Database.
UserName 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.

managedDatabaseId String: The OCID of the Managed Database.
userName 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.

managedDatabaseId string: The OCID of the Managed Database.
userName 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_id str: 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.

managedDatabaseId String: The OCID of the Managed Database.
userName 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.

getManagedDatabaseUserObjectPrivilege Result

The following output properties are available:

Id string: The provider-assigned unique ID for this managed resource.
Items List<GetManagedDatabaseUserObjectPrivilegeItem>: An array of object privileges.
ManagedDatabaseId string
UserName string
Name string: The name of the privilege on the object.

Id string: The provider-assigned unique ID for this managed resource.
Items []GetManagedDatabaseUserObjectPrivilegeItem: An array of object privileges.
ManagedDatabaseId string
UserName string
Name string: The name of the privilege on the object.

id String: The provider-assigned unique ID for this managed resource.
items List<GetManagedDatabaseUserObjectPrivilegeItem>: An array of object privileges.
managedDatabaseId String
userName String
name String: The name of the privilege on the object.

id string: The provider-assigned unique ID for this managed resource.
items GetManagedDatabaseUserObjectPrivilegeItem[]: An array of object privileges.
managedDatabaseId string
userName string
name string: The name of the privilege on the object.

id str: The provider-assigned unique ID for this managed resource.
items GetManagedDatabaseUserObjectPrivilegeItem]: An array of object privileges.
managed_database_id str
user_name str
name str: The name of the privilege on the object.

id String: The provider-assigned unique ID for this managed resource.
items List<Property Map>: An array of object privileges.
managedDatabaseId String
userName String
name String: The name of the privilege on the object.

Supporting Types

GetManagedDatabaseUserObjectPrivilegeItem

Common string: Indicates how the object privilege was granted. Possible values: YES if the role is granted commonly (CONTAINER=ALL is used) NO if the role is granted locally (CONTAINER=ALL is not used)
GrantOption string: Indicates whether the privilege is granted with the GRANT OPTION (YES) or not (NO).
Grantor string: The name of the user who granted the object privilege.
Hierarchy string: Indicates whether the privilege is granted with the HIERARCHY OPTION (YES) or not (NO).
Inherited string: Indicates whether the granted privilege is inherited from another container (YES) or not (NO).
Name string: A filter to return only resources that match the entire name.
Object string: The name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.
Owner string: The owner of the object.
SchemaType string: The type of object.

Common string: Indicates how the object privilege was granted. Possible values: YES if the role is granted commonly (CONTAINER=ALL is used) NO if the role is granted locally (CONTAINER=ALL is not used)
GrantOption string: Indicates whether the privilege is granted with the GRANT OPTION (YES) or not (NO).
Grantor string: The name of the user who granted the object privilege.
Hierarchy string: Indicates whether the privilege is granted with the HIERARCHY OPTION (YES) or not (NO).
Inherited string: Indicates whether the granted privilege is inherited from another container (YES) or not (NO).
Name string: A filter to return only resources that match the entire name.
Object string: The name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.
Owner string: The owner of the object.
SchemaType string: The type of object.

common String: Indicates how the object privilege was granted. Possible values: YES if the role is granted commonly (CONTAINER=ALL is used) NO if the role is granted locally (CONTAINER=ALL is not used)
grantOption String: Indicates whether the privilege is granted with the GRANT OPTION (YES) or not (NO).
grantor String: The name of the user who granted the object privilege.
hierarchy String: Indicates whether the privilege is granted with the HIERARCHY OPTION (YES) or not (NO).
inherited String: Indicates whether the granted privilege is inherited from another container (YES) or not (NO).
name String: A filter to return only resources that match the entire name.
object String: The name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.
owner String: The owner of the object.
schemaType String: The type of object.

common string: Indicates how the object privilege was granted. Possible values: YES if the role is granted commonly (CONTAINER=ALL is used) NO if the role is granted locally (CONTAINER=ALL is not used)
grantOption string: Indicates whether the privilege is granted with the GRANT OPTION (YES) or not (NO).
grantor string: The name of the user who granted the object privilege.
hierarchy string: Indicates whether the privilege is granted with the HIERARCHY OPTION (YES) or not (NO).
inherited string: Indicates whether the granted privilege is inherited from another container (YES) or not (NO).
name string: A filter to return only resources that match the entire name.
object string: The name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.
owner string: The owner of the object.
schemaType string: The type of object.

common str: Indicates how the object privilege was granted. Possible values: YES if the role is granted commonly (CONTAINER=ALL is used) NO if the role is granted locally (CONTAINER=ALL is not used)
grant_option str: Indicates whether the privilege is granted with the GRANT OPTION (YES) or not (NO).
grantor str: The name of the user who granted the object privilege.
hierarchy str: Indicates whether the privilege is granted with the HIERARCHY OPTION (YES) or not (NO).
inherited str: Indicates whether the granted privilege is inherited from another container (YES) or not (NO).
name str: A filter to return only resources that match the entire name.
object str: The name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.
owner str: The owner of the object.
schema_type str: The type of object.

common String: Indicates how the object privilege was granted. Possible values: YES if the role is granted commonly (CONTAINER=ALL is used) NO if the role is granted locally (CONTAINER=ALL is not used)
grantOption String: Indicates whether the privilege is granted with the GRANT OPTION (YES) or not (NO).
grantor String: The name of the user who granted the object privilege.
hierarchy String: Indicates whether the privilege is granted with the HIERARCHY OPTION (YES) or not (NO).
inherited String: Indicates whether the granted privilege is inherited from another container (YES) or not (NO).
name String: A filter to return only resources that match the entire name.
object String: The name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.
owner String: The owner of the object.
schemaType String: The type of object.

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v1.11.0 published on Wednesday, Sep 27, 2023 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseUserObjectPrivilege

On this page

On this page

Example Usage

Using getManagedDatabaseUserObjectPrivilege

getManagedDatabaseUserObjectPrivilege Result

Supporting Types

GetManagedDatabaseUserObjectPrivilegeItem

Package Details

On this page

On this page