1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSecurityPolicyReportDatabaseViewAccessEntry
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

oci.DataSafe.getSecurityPolicyReportDatabaseViewAccessEntry

Explore with Pulumi AI

This data source provides details about a specific Security Policy Report Database View Access Entry resource in Oracle Cloud Infrastructure Data Safe service.

Gets a database view access object by identifier.

Example Usage

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

const testSecurityPolicyReportDatabaseViewAccessEntry = oci.DataSafe.getSecurityPolicyReportDatabaseViewAccessEntry({
    databaseViewAccessEntryKey: securityPolicyReportDatabaseViewAccessEntryDatabaseViewAccessEntryKey,
    securityPolicyReportId: testSecurityPolicyReport.id,
});
Copy
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"])
Copy
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
	})
}
Copy
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,
    });

});
Copy
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());

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

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>
Copy
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]
Copy
func GetSecurityPolicyReportDatabaseViewAccessEntry(ctx *Context, args *GetSecurityPolicyReportDatabaseViewAccessEntryArgs, opts ...InvokeOption) (*GetSecurityPolicyReportDatabaseViewAccessEntryResult, error)
func GetSecurityPolicyReportDatabaseViewAccessEntryOutput(ctx *Context, args *GetSecurityPolicyReportDatabaseViewAccessEntryOutputArgs, opts ...InvokeOption) GetSecurityPolicyReportDatabaseViewAccessEntryResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetSecurityPolicyReportDatabaseViewAccessEntryResult> getSecurityPolicyReportDatabaseViewAccessEntry(GetSecurityPolicyReportDatabaseViewAccessEntryArgs args, InvokeOptions options)
public static Output<GetSecurityPolicyReportDatabaseViewAccessEntryResult> getSecurityPolicyReportDatabaseViewAccessEntry(GetSecurityPolicyReportDatabaseViewAccessEntryArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DataSafe/getSecurityPolicyReportDatabaseViewAccessEntry:getSecurityPolicyReportDatabaseViewAccessEntry
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

DatabaseViewAccessEntryKey This property is required. string
The unique key that identifies the view access object. This is a system-generated identifier.
SecurityPolicyReportId This property is required. string
The OCID of the security policy report resource.
DatabaseViewAccessEntryKey This property is required. string
The unique key that identifies the view access object. This is a system-generated identifier.
SecurityPolicyReportId This property is required. string
The OCID of the security policy report resource.
databaseViewAccessEntryKey This property is required. String
The unique key that identifies the view access object. This is a system-generated identifier.
securityPolicyReportId This property is required. String
The OCID of the security policy report resource.
databaseViewAccessEntryKey This property is required. string
The unique key that identifies the view access object. This is a system-generated identifier.
securityPolicyReportId This property is required. string
The OCID of the security policy report resource.
database_view_access_entry_key This property is required. str
The unique key that identifies the view access object. This is a system-generated identifier.
security_policy_report_id This property is required. str
The OCID of the security policy report resource.
databaseViewAccessEntryKey This property is required. String
The unique key that identifies the view access object. This is a system-generated identifier.
securityPolicyReportId This property is required. 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.