oci.DataSafe.getSecurityPolicyReportDatabaseViewAccessEntry

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

Example Usage

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

const testSecurityPolicyReportDatabaseViewAccessEntry = oci.DataSafe.getSecurityPolicyReportDatabaseViewAccessEntry({
    databaseViewAccessEntryKey: securityPolicyReportDatabaseViewAccessEntryDatabaseViewAccessEntryKey,
    securityPolicyReportId: testSecurityPolicyReport.id,
});

import pulumi
import pulumi_oci as oci

test_security_policy_report_database_view_access_entry = oci.DataSafe.get_security_policy_report_database_view_access_entry(database_view_access_entry_key=security_policy_report_database_view_access_entry_database_view_access_entry_key,
    security_policy_report_id=test_security_policy_report["id"])

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/datasafe"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := datasafe.GetSecurityPolicyReportDatabaseViewAccessEntry(ctx, &datasafe.GetSecurityPolicyReportDatabaseViewAccessEntryArgs{
			DatabaseViewAccessEntryKey: securityPolicyReportDatabaseViewAccessEntryDatabaseViewAccessEntryKey,
			SecurityPolicyReportId:     testSecurityPolicyReport.Id,
		}, 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 testSecurityPolicyReportDatabaseViewAccessEntry = Oci.DataSafe.GetSecurityPolicyReportDatabaseViewAccessEntry.Invoke(new()
    {
        DatabaseViewAccessEntryKey = securityPolicyReportDatabaseViewAccessEntryDatabaseViewAccessEntryKey,
        SecurityPolicyReportId = testSecurityPolicyReport.Id,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DataSafe.DataSafeFunctions;
import com.pulumi.oci.DataSafe.inputs.GetSecurityPolicyReportDatabaseViewAccessEntryArgs;
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 testSecurityPolicyReportDatabaseViewAccessEntry = DataSafeFunctions.getSecurityPolicyReportDatabaseViewAccessEntry(GetSecurityPolicyReportDatabaseViewAccessEntryArgs.builder()
            .databaseViewAccessEntryKey(securityPolicyReportDatabaseViewAccessEntryDatabaseViewAccessEntryKey)
            .securityPolicyReportId(testSecurityPolicyReport.id())
            .build());

    }
}

variables:
  testSecurityPolicyReportDatabaseViewAccessEntry:
    fn::invoke:
      function: oci:DataSafe:getSecurityPolicyReportDatabaseViewAccessEntry
      arguments:
        databaseViewAccessEntryKey: ${securityPolicyReportDatabaseViewAccessEntryDatabaseViewAccessEntryKey}
        securityPolicyReportId: ${testSecurityPolicyReport.id}

Using getSecurityPolicyReportDatabaseViewAccessEntry

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 getSecurityPolicyReportDatabaseViewAccessEntry(args: GetSecurityPolicyReportDatabaseViewAccessEntryArgs, opts?: InvokeOptions): Promise<GetSecurityPolicyReportDatabaseViewAccessEntryResult>
function getSecurityPolicyReportDatabaseViewAccessEntryOutput(args: GetSecurityPolicyReportDatabaseViewAccessEntryOutputArgs, opts?: InvokeOptions): Output<GetSecurityPolicyReportDatabaseViewAccessEntryResult>

def get_security_policy_report_database_view_access_entry(database_view_access_entry_key: Optional[str] = None,
                                                          security_policy_report_id: Optional[str] = None,
                                                          opts: Optional[InvokeOptions] = None) -> GetSecurityPolicyReportDatabaseViewAccessEntryResult
def get_security_policy_report_database_view_access_entry_output(database_view_access_entry_key: Optional[pulumi.Input[str]] = None,
                                                          security_policy_report_id: Optional[pulumi.Input[str]] = None,
                                                          opts: Optional[InvokeOptions] = None) -> Output[GetSecurityPolicyReportDatabaseViewAccessEntryResult]

func GetSecurityPolicyReportDatabaseViewAccessEntry(ctx *Context, args *GetSecurityPolicyReportDatabaseViewAccessEntryArgs, opts ...InvokeOption) (*GetSecurityPolicyReportDatabaseViewAccessEntryResult, error)
func GetSecurityPolicyReportDatabaseViewAccessEntryOutput(ctx *Context, args *GetSecurityPolicyReportDatabaseViewAccessEntryOutputArgs, opts ...InvokeOption) GetSecurityPolicyReportDatabaseViewAccessEntryResultOutput

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

public static class GetSecurityPolicyReportDatabaseViewAccessEntry 
{
    public static Task<GetSecurityPolicyReportDatabaseViewAccessEntryResult> InvokeAsync(GetSecurityPolicyReportDatabaseViewAccessEntryArgs args, InvokeOptions? opts = null)
    public static Output<GetSecurityPolicyReportDatabaseViewAccessEntryResult> Invoke(GetSecurityPolicyReportDatabaseViewAccessEntryInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetSecurityPolicyReportDatabaseViewAccessEntryResult> getSecurityPolicyReportDatabaseViewAccessEntry(GetSecurityPolicyReportDatabaseViewAccessEntryArgs args, InvokeOptions options)
public static Output<GetSecurityPolicyReportDatabaseViewAccessEntryResult> getSecurityPolicyReportDatabaseViewAccessEntry(GetSecurityPolicyReportDatabaseViewAccessEntryArgs args, InvokeOptions options)

fn::invoke:
  function: oci:DataSafe/getSecurityPolicyReportDatabaseViewAccessEntry:getSecurityPolicyReportDatabaseViewAccessEntry
  arguments:
    # arguments dictionary

The following arguments are supported:

DatabaseViewAccessEntryKey string: The unique key that identifies the view access object. This is a system-generated identifier.
SecurityPolicyReportId string: The OCID of the security policy report resource.

DatabaseViewAccessEntryKey string: The unique key that identifies the view access object. This is a system-generated identifier.
SecurityPolicyReportId string: The OCID of the security policy report resource.

databaseViewAccessEntryKey String: The unique key that identifies the view access object. This is a system-generated identifier.
securityPolicyReportId String: The OCID of the security policy report resource.

databaseViewAccessEntryKey string: The unique key that identifies the view access object. This is a system-generated identifier.
securityPolicyReportId string: The OCID of the security policy report resource.

database_view_access_entry_key str: The unique key that identifies the view access object. This is a system-generated identifier.
security_policy_report_id str: The OCID of the security policy report resource.

databaseViewAccessEntryKey String: The unique key that identifies the view access object. This is a system-generated identifier.
securityPolicyReportId String: The OCID of the security policy report resource.

getSecurityPolicyReportDatabaseViewAccessEntry Result

The following output properties are available:

AccessType string: The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT or DELETE.
ColumnName string: If there are column level privileges on a table or view.
DatabaseViewAccessEntryKey string
GrantFromRole string: This can be empty in case of direct grant, in case of indirect grant, this attribute displays the name of the role which is granted to the user though which the user has access to the table.
Grantee string: Grantee is the user who can access the table or view
Grantor string: The user who granted the privilege.
Id string: The provider-assigned unique ID for this managed resource.
IsAccessConstrainedByDatabaseVault bool: Indicates whether the table access is constrained via Oracle Database Vault.
IsAccessConstrainedByRealApplicationSecurity bool: Indicates whether the view access is constrained via Real Application Security.
IsAccessConstrainedByRedaction bool: Indicates whether the view access is constrained via Oracle Data Redaction.
IsAccessConstrainedBySqlFirewall bool: Indicates whether the view access is constrained via Oracle Database SQL Firewall.
IsAccessConstrainedByVirtualPrivateDatabase bool: Indicates whether the view access is constrained via Virtual Private Database.
Key string: The unique key that identifies the table access report. It is numeric and unique within a security policy report.
Privilege string: The name of the privilege.
PrivilegeGrantable string: Indicates whether the grantee can grant this privilege to other users. Privileges can be granted to a user or role with GRANT_OPTION or ADMIN_OPTION
PrivilegeType string: Type of the privilege user has, this includes System Privilege, Schema Privilege, Object Privilege, Column Privilege, Owner or Schema Privilege on a schema.
SecurityPolicyReportId string
TableName string: The name of the database table the user has access to.
TableSchema string: The name of the schema the table belongs to.
TargetId string: The OCID of the of the target database.
ViewName string: The name of the view.
ViewSchema string: The name of the schema.
ViewText string: Definition of the view.

AccessType string: The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT or DELETE.
ColumnName string: If there are column level privileges on a table or view.
DatabaseViewAccessEntryKey string
GrantFromRole string: This can be empty in case of direct grant, in case of indirect grant, this attribute displays the name of the role which is granted to the user though which the user has access to the table.
Grantee string: Grantee is the user who can access the table or view
Grantor string: The user who granted the privilege.
Id string: The provider-assigned unique ID for this managed resource.
IsAccessConstrainedByDatabaseVault bool: Indicates whether the table access is constrained via Oracle Database Vault.
IsAccessConstrainedByRealApplicationSecurity bool: Indicates whether the view access is constrained via Real Application Security.
IsAccessConstrainedByRedaction bool: Indicates whether the view access is constrained via Oracle Data Redaction.
IsAccessConstrainedBySqlFirewall bool: Indicates whether the view access is constrained via Oracle Database SQL Firewall.
IsAccessConstrainedByVirtualPrivateDatabase bool: Indicates whether the view access is constrained via Virtual Private Database.
Key string: The unique key that identifies the table access report. It is numeric and unique within a security policy report.
Privilege string: The name of the privilege.
PrivilegeGrantable string: Indicates whether the grantee can grant this privilege to other users. Privileges can be granted to a user or role with GRANT_OPTION or ADMIN_OPTION
PrivilegeType string: Type of the privilege user has, this includes System Privilege, Schema Privilege, Object Privilege, Column Privilege, Owner or Schema Privilege on a schema.
SecurityPolicyReportId string
TableName string: The name of the database table the user has access to.
TableSchema string: The name of the schema the table belongs to.
TargetId string: The OCID of the of the target database.
ViewName string: The name of the view.
ViewSchema string: The name of the schema.
ViewText string: Definition of the view.

accessType String: The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT or DELETE.
columnName String: If there are column level privileges on a table or view.
databaseViewAccessEntryKey String
grantFromRole String: This can be empty in case of direct grant, in case of indirect grant, this attribute displays the name of the role which is granted to the user though which the user has access to the table.
grantee String: Grantee is the user who can access the table or view
grantor String: The user who granted the privilege.
id String: The provider-assigned unique ID for this managed resource.
isAccessConstrainedByDatabaseVault Boolean: Indicates whether the table access is constrained via Oracle Database Vault.
isAccessConstrainedByRealApplicationSecurity Boolean: Indicates whether the view access is constrained via Real Application Security.
isAccessConstrainedByRedaction Boolean: Indicates whether the view access is constrained via Oracle Data Redaction.
isAccessConstrainedBySqlFirewall Boolean: Indicates whether the view access is constrained via Oracle Database SQL Firewall.
isAccessConstrainedByVirtualPrivateDatabase Boolean: Indicates whether the view access is constrained via Virtual Private Database.
key String: The unique key that identifies the table access report. It is numeric and unique within a security policy report.
privilege String: The name of the privilege.
privilegeGrantable String: Indicates whether the grantee can grant this privilege to other users. Privileges can be granted to a user or role with GRANT_OPTION or ADMIN_OPTION
privilegeType String: Type of the privilege user has, this includes System Privilege, Schema Privilege, Object Privilege, Column Privilege, Owner or Schema Privilege on a schema.
securityPolicyReportId String
tableName String: The name of the database table the user has access to.
tableSchema String: The name of the schema the table belongs to.
targetId String: The OCID of the of the target database.
viewName String: The name of the view.
viewSchema String: The name of the schema.
viewText String: Definition of the view.

accessType string: The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT or DELETE.
columnName string: If there are column level privileges on a table or view.
databaseViewAccessEntryKey string
grantFromRole string: This can be empty in case of direct grant, in case of indirect grant, this attribute displays the name of the role which is granted to the user though which the user has access to the table.
grantee string: Grantee is the user who can access the table or view
grantor string: The user who granted the privilege.
id string: The provider-assigned unique ID for this managed resource.
isAccessConstrainedByDatabaseVault boolean: Indicates whether the table access is constrained via Oracle Database Vault.
isAccessConstrainedByRealApplicationSecurity boolean: Indicates whether the view access is constrained via Real Application Security.
isAccessConstrainedByRedaction boolean: Indicates whether the view access is constrained via Oracle Data Redaction.
isAccessConstrainedBySqlFirewall boolean: Indicates whether the view access is constrained via Oracle Database SQL Firewall.
isAccessConstrainedByVirtualPrivateDatabase boolean: Indicates whether the view access is constrained via Virtual Private Database.
key string: The unique key that identifies the table access report. It is numeric and unique within a security policy report.
privilege string: The name of the privilege.
privilegeGrantable string: Indicates whether the grantee can grant this privilege to other users. Privileges can be granted to a user or role with GRANT_OPTION or ADMIN_OPTION
privilegeType string: Type of the privilege user has, this includes System Privilege, Schema Privilege, Object Privilege, Column Privilege, Owner or Schema Privilege on a schema.
securityPolicyReportId string
tableName string: The name of the database table the user has access to.
tableSchema string: The name of the schema the table belongs to.
targetId string: The OCID of the of the target database.
viewName string: The name of the view.
viewSchema string: The name of the schema.
viewText string: Definition of the view.

access_type str: The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT or DELETE.
column_name str: If there are column level privileges on a table or view.
database_view_access_entry_key str
grant_from_role str: This can be empty in case of direct grant, in case of indirect grant, this attribute displays the name of the role which is granted to the user though which the user has access to the table.
grantee str: Grantee is the user who can access the table or view
grantor str: The user who granted the privilege.
id str: The provider-assigned unique ID for this managed resource.
is_access_constrained_by_database_vault bool: Indicates whether the table access is constrained via Oracle Database Vault.
is_access_constrained_by_real_application_security bool: Indicates whether the view access is constrained via Real Application Security.
is_access_constrained_by_redaction bool: Indicates whether the view access is constrained via Oracle Data Redaction.
is_access_constrained_by_sql_firewall bool: Indicates whether the view access is constrained via Oracle Database SQL Firewall.
is_access_constrained_by_virtual_private_database bool: Indicates whether the view access is constrained via Virtual Private Database.
key str: The unique key that identifies the table access report. It is numeric and unique within a security policy report.
privilege str: The name of the privilege.
privilege_grantable str: Indicates whether the grantee can grant this privilege to other users. Privileges can be granted to a user or role with GRANT_OPTION or ADMIN_OPTION
privilege_type str: Type of the privilege user has, this includes System Privilege, Schema Privilege, Object Privilege, Column Privilege, Owner or Schema Privilege on a schema.
security_policy_report_id str
table_name str: The name of the database table the user has access to.
table_schema str: The name of the schema the table belongs to.
target_id str: The OCID of the of the target database.
view_name str: The name of the view.
view_schema str: The name of the schema.
view_text str: Definition of the view.

accessType String: The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT or DELETE.
columnName String: If there are column level privileges on a table or view.
databaseViewAccessEntryKey String
grantFromRole String: This can be empty in case of direct grant, in case of indirect grant, this attribute displays the name of the role which is granted to the user though which the user has access to the table.
grantee String: Grantee is the user who can access the table or view
grantor String: The user who granted the privilege.
id String: The provider-assigned unique ID for this managed resource.
isAccessConstrainedByDatabaseVault Boolean: Indicates whether the table access is constrained via Oracle Database Vault.
isAccessConstrainedByRealApplicationSecurity Boolean: Indicates whether the view access is constrained via Real Application Security.
isAccessConstrainedByRedaction Boolean: Indicates whether the view access is constrained via Oracle Data Redaction.
isAccessConstrainedBySqlFirewall Boolean: Indicates whether the view access is constrained via Oracle Database SQL Firewall.
isAccessConstrainedByVirtualPrivateDatabase Boolean: Indicates whether the view access is constrained via Virtual Private Database.
key String: The unique key that identifies the table access report. It is numeric and unique within a security policy report.
privilege String: The name of the privilege.
privilegeGrantable String: Indicates whether the grantee can grant this privilege to other users. Privileges can be granted to a user or role with GRANT_OPTION or ADMIN_OPTION
privilegeType String: Type of the privilege user has, this includes System Privilege, Schema Privilege, Object Privilege, Column Privilege, Owner or Schema Privilege on a schema.
securityPolicyReportId String
tableName String: The name of the database table the user has access to.
tableSchema String: The name of the schema the table belongs to.
targetId String: The OCID of the of the target database.
viewName String: The name of the view.
viewSchema String: The name of the schema.
viewText String: Definition of the view.

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 v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

pulumi/pulumi-oci

oci.DataSafe.getSecurityPolicyReportDatabaseViewAccessEntry

On this page

On this page

Example Usage

Using getSecurityPolicyReportDatabaseViewAccessEntry

getSecurityPolicyReportDatabaseViewAccessEntry Result

Package Details

On this page

On this page