oci.DataSafe.getSecurityPolicyReportDatabaseViewAccessEntries
Explore with Pulumi AI
This data source provides the list of Security Policy Report Database View Access Entries in Oracle Cloud Infrastructure Data Safe service.
Retrieves a list of all database view access entries in Data Safe.
The ListDatabaseViewAccessEntries operation returns only the database view access objects for the specified security policy report.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testSecurityPolicyReportDatabaseViewAccessEntries = oci.DataSafe.getSecurityPolicyReportDatabaseViewAccessEntries({
    securityPolicyReportId: testSecurityPolicyReport.id,
    scimQuery: securityPolicyReportDatabaseViewAccessEntryScimQuery,
    targetId: testTarget.id,
});
import pulumi
import pulumi_oci as oci
test_security_policy_report_database_view_access_entries = oci.DataSafe.get_security_policy_report_database_view_access_entries(security_policy_report_id=test_security_policy_report["id"],
    scim_query=security_policy_report_database_view_access_entry_scim_query,
    target_id=test_target["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.GetSecurityPolicyReportDatabaseViewAccessEntries(ctx, &datasafe.GetSecurityPolicyReportDatabaseViewAccessEntriesArgs{
			SecurityPolicyReportId: testSecurityPolicyReport.Id,
			ScimQuery:              pulumi.StringRef(securityPolicyReportDatabaseViewAccessEntryScimQuery),
			TargetId:               pulumi.StringRef(testTarget.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 testSecurityPolicyReportDatabaseViewAccessEntries = Oci.DataSafe.GetSecurityPolicyReportDatabaseViewAccessEntries.Invoke(new()
    {
        SecurityPolicyReportId = testSecurityPolicyReport.Id,
        ScimQuery = securityPolicyReportDatabaseViewAccessEntryScimQuery,
        TargetId = testTarget.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.GetSecurityPolicyReportDatabaseViewAccessEntriesArgs;
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 testSecurityPolicyReportDatabaseViewAccessEntries = DataSafeFunctions.getSecurityPolicyReportDatabaseViewAccessEntries(GetSecurityPolicyReportDatabaseViewAccessEntriesArgs.builder()
            .securityPolicyReportId(testSecurityPolicyReport.id())
            .scimQuery(securityPolicyReportDatabaseViewAccessEntryScimQuery)
            .targetId(testTarget.id())
            .build());
    }
}
variables:
  testSecurityPolicyReportDatabaseViewAccessEntries:
    fn::invoke:
      function: oci:DataSafe:getSecurityPolicyReportDatabaseViewAccessEntries
      arguments:
        securityPolicyReportId: ${testSecurityPolicyReport.id}
        scimQuery: ${securityPolicyReportDatabaseViewAccessEntryScimQuery}
        targetId: ${testTarget.id}
Using getSecurityPolicyReportDatabaseViewAccessEntries
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 getSecurityPolicyReportDatabaseViewAccessEntries(args: GetSecurityPolicyReportDatabaseViewAccessEntriesArgs, opts?: InvokeOptions): Promise<GetSecurityPolicyReportDatabaseViewAccessEntriesResult>
function getSecurityPolicyReportDatabaseViewAccessEntriesOutput(args: GetSecurityPolicyReportDatabaseViewAccessEntriesOutputArgs, opts?: InvokeOptions): Output<GetSecurityPolicyReportDatabaseViewAccessEntriesResult>def get_security_policy_report_database_view_access_entries(filters: Optional[Sequence[GetSecurityPolicyReportDatabaseViewAccessEntriesFilter]] = None,
                                                            scim_query: Optional[str] = None,
                                                            security_policy_report_id: Optional[str] = None,
                                                            target_id: Optional[str] = None,
                                                            opts: Optional[InvokeOptions] = None) -> GetSecurityPolicyReportDatabaseViewAccessEntriesResult
def get_security_policy_report_database_view_access_entries_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetSecurityPolicyReportDatabaseViewAccessEntriesFilterArgs]]]] = None,
                                                            scim_query: Optional[pulumi.Input[str]] = None,
                                                            security_policy_report_id: Optional[pulumi.Input[str]] = None,
                                                            target_id: Optional[pulumi.Input[str]] = None,
                                                            opts: Optional[InvokeOptions] = None) -> Output[GetSecurityPolicyReportDatabaseViewAccessEntriesResult]func GetSecurityPolicyReportDatabaseViewAccessEntries(ctx *Context, args *GetSecurityPolicyReportDatabaseViewAccessEntriesArgs, opts ...InvokeOption) (*GetSecurityPolicyReportDatabaseViewAccessEntriesResult, error)
func GetSecurityPolicyReportDatabaseViewAccessEntriesOutput(ctx *Context, args *GetSecurityPolicyReportDatabaseViewAccessEntriesOutputArgs, opts ...InvokeOption) GetSecurityPolicyReportDatabaseViewAccessEntriesResultOutput> Note: This function is named GetSecurityPolicyReportDatabaseViewAccessEntries in the Go SDK.
public static class GetSecurityPolicyReportDatabaseViewAccessEntries 
{
    public static Task<GetSecurityPolicyReportDatabaseViewAccessEntriesResult> InvokeAsync(GetSecurityPolicyReportDatabaseViewAccessEntriesArgs args, InvokeOptions? opts = null)
    public static Output<GetSecurityPolicyReportDatabaseViewAccessEntriesResult> Invoke(GetSecurityPolicyReportDatabaseViewAccessEntriesInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetSecurityPolicyReportDatabaseViewAccessEntriesResult> getSecurityPolicyReportDatabaseViewAccessEntries(GetSecurityPolicyReportDatabaseViewAccessEntriesArgs args, InvokeOptions options)
public static Output<GetSecurityPolicyReportDatabaseViewAccessEntriesResult> getSecurityPolicyReportDatabaseViewAccessEntries(GetSecurityPolicyReportDatabaseViewAccessEntriesArgs args, InvokeOptions options)
fn::invoke:
  function: oci:DataSafe/getSecurityPolicyReportDatabaseViewAccessEntries:getSecurityPolicyReportDatabaseViewAccessEntries
  arguments:
    # arguments dictionaryThe following arguments are supported:
- SecurityPolicy stringReport Id 
- The OCID of the security policy report resource.
- Filters
List<GetSecurity Policy Report Database View Access Entries Filter> 
- ScimQuery string
- The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.) - Example: query=(accessType eq 'SELECT') and (grantee eq 'ADMIN') 
- TargetId string
- A filter to return only items related to a specific target OCID.
- SecurityPolicy stringReport Id 
- The OCID of the security policy report resource.
- Filters
[]GetSecurity Policy Report Database View Access Entries Filter 
- ScimQuery string
- The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.) - Example: query=(accessType eq 'SELECT') and (grantee eq 'ADMIN') 
- TargetId string
- A filter to return only items related to a specific target OCID.
- securityPolicy StringReport Id 
- The OCID of the security policy report resource.
- filters
List<GetSecurity Policy Report Database View Access Entries Filter> 
- scimQuery String
- The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.) - Example: query=(accessType eq 'SELECT') and (grantee eq 'ADMIN') 
- targetId String
- A filter to return only items related to a specific target OCID.
- securityPolicy stringReport Id 
- The OCID of the security policy report resource.
- filters
GetSecurity Policy Report Database View Access Entries Filter[] 
- scimQuery string
- The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.) - Example: query=(accessType eq 'SELECT') and (grantee eq 'ADMIN') 
- targetId string
- A filter to return only items related to a specific target OCID.
- security_policy_ strreport_ id 
- The OCID of the security policy report resource.
- filters
Sequence[GetSecurity Policy Report Database View Access Entries Filter] 
- scim_query str
- The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.) - Example: query=(accessType eq 'SELECT') and (grantee eq 'ADMIN') 
- target_id str
- A filter to return only items related to a specific target OCID.
- securityPolicy StringReport Id 
- The OCID of the security policy report resource.
- filters List<Property Map>
- scimQuery String
- The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.) - Example: query=(accessType eq 'SELECT') and (grantee eq 'ADMIN') 
- targetId String
- A filter to return only items related to a specific target OCID.
getSecurityPolicyReportDatabaseViewAccessEntries Result
The following output properties are available:
- DatabaseView List<GetAccess Entry Collections Security Policy Report Database View Access Entries Database View Access Entry Collection> 
- The list of database_view_access_entry_collection.
- Id string
- The provider-assigned unique ID for this managed resource.
- SecurityPolicy stringReport Id 
- Filters
List<GetSecurity Policy Report Database View Access Entries Filter> 
- ScimQuery string
- TargetId string
- The OCID of the of the target database.
- DatabaseView []GetAccess Entry Collections Security Policy Report Database View Access Entries Database View Access Entry Collection 
- The list of database_view_access_entry_collection.
- Id string
- The provider-assigned unique ID for this managed resource.
- SecurityPolicy stringReport Id 
- Filters
[]GetSecurity Policy Report Database View Access Entries Filter 
- ScimQuery string
- TargetId string
- The OCID of the of the target database.
- databaseView List<GetAccess Entry Collections Security Policy Report Database View Access Entries Database View Access Entry Collection> 
- The list of database_view_access_entry_collection.
- id String
- The provider-assigned unique ID for this managed resource.
- securityPolicy StringReport Id 
- filters
List<GetSecurity Policy Report Database View Access Entries Filter> 
- scimQuery String
- targetId String
- The OCID of the of the target database.
- databaseView GetAccess Entry Collections Security Policy Report Database View Access Entries Database View Access Entry Collection[] 
- The list of database_view_access_entry_collection.
- id string
- The provider-assigned unique ID for this managed resource.
- securityPolicy stringReport Id 
- filters
GetSecurity Policy Report Database View Access Entries Filter[] 
- scimQuery string
- targetId string
- The OCID of the of the target database.
- database_view_ Sequence[Getaccess_ entry_ collections Security Policy Report Database View Access Entries Database View Access Entry Collection] 
- The list of database_view_access_entry_collection.
- id str
- The provider-assigned unique ID for this managed resource.
- security_policy_ strreport_ id 
- filters
Sequence[GetSecurity Policy Report Database View Access Entries Filter] 
- scim_query str
- target_id str
- The OCID of the of the target database.
- databaseView List<Property Map>Access Entry Collections 
- The list of database_view_access_entry_collection.
- id String
- The provider-assigned unique ID for this managed resource.
- securityPolicy StringReport Id 
- filters List<Property Map>
- scimQuery String
- targetId String
- The OCID of the of the target database.
Supporting Types
GetSecurityPolicyReportDatabaseViewAccessEntriesDatabaseViewAccessEntryCollection            
GetSecurityPolicyReportDatabaseViewAccessEntriesDatabaseViewAccessEntryCollectionItem             
- 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.
- GrantFrom stringRole 
- 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.
- IsAccess boolConstrained By Database Vault 
- Indicates whether the table access is constrained via Oracle Database Vault.
- IsAccess boolConstrained By Real Application Security 
- Indicates whether the view access is constrained via Real Application Security.
- IsAccess boolConstrained By Redaction 
- Indicates whether the view access is constrained via Oracle Data Redaction.
- IsAccess boolConstrained By Sql Firewall 
- Indicates whether the view access is constrained via Oracle Database SQL Firewall.
- IsAccess boolConstrained By Virtual Private Database 
- 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.
- 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
- A filter to return only items related to a specific target OCID.
- 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.
- GrantFrom stringRole 
- 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.
- IsAccess boolConstrained By Database Vault 
- Indicates whether the table access is constrained via Oracle Database Vault.
- IsAccess boolConstrained By Real Application Security 
- Indicates whether the view access is constrained via Real Application Security.
- IsAccess boolConstrained By Redaction 
- Indicates whether the view access is constrained via Oracle Data Redaction.
- IsAccess boolConstrained By Sql Firewall 
- Indicates whether the view access is constrained via Oracle Database SQL Firewall.
- IsAccess boolConstrained By Virtual Private Database 
- 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.
- 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
- A filter to return only items related to a specific target OCID.
- 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.
- grantFrom StringRole 
- 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.
- isAccess BooleanConstrained By Database Vault 
- Indicates whether the table access is constrained via Oracle Database Vault.
- isAccess BooleanConstrained By Real Application Security 
- Indicates whether the view access is constrained via Real Application Security.
- isAccess BooleanConstrained By Redaction 
- Indicates whether the view access is constrained via Oracle Data Redaction.
- isAccess BooleanConstrained By Sql Firewall 
- Indicates whether the view access is constrained via Oracle Database SQL Firewall.
- isAccess BooleanConstrained By Virtual Private Database 
- 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.
- 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
- A filter to return only items related to a specific target OCID.
- 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.
- grantFrom stringRole 
- 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.
- isAccess booleanConstrained By Database Vault 
- Indicates whether the table access is constrained via Oracle Database Vault.
- isAccess booleanConstrained By Real Application Security 
- Indicates whether the view access is constrained via Real Application Security.
- isAccess booleanConstrained By Redaction 
- Indicates whether the view access is constrained via Oracle Data Redaction.
- isAccess booleanConstrained By Sql Firewall 
- Indicates whether the view access is constrained via Oracle Database SQL Firewall.
- isAccess booleanConstrained By Virtual Private Database 
- 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.
- 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
- A filter to return only items related to a specific target OCID.
- 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.
- grant_from_ strrole 
- 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.
- is_access_ boolconstrained_ by_ database_ vault 
- Indicates whether the table access is constrained via Oracle Database Vault.
- is_access_ boolconstrained_ by_ real_ application_ security 
- Indicates whether the view access is constrained via Real Application Security.
- is_access_ boolconstrained_ by_ redaction 
- Indicates whether the view access is constrained via Oracle Data Redaction.
- is_access_ boolconstrained_ by_ sql_ firewall 
- Indicates whether the view access is constrained via Oracle Database SQL Firewall.
- is_access_ boolconstrained_ by_ virtual_ private_ database 
- 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.
- 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
- A filter to return only items related to a specific target OCID.
- 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.
- grantFrom StringRole 
- 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.
- isAccess BooleanConstrained By Database Vault 
- Indicates whether the table access is constrained via Oracle Database Vault.
- isAccess BooleanConstrained By Real Application Security 
- Indicates whether the view access is constrained via Real Application Security.
- isAccess BooleanConstrained By Redaction 
- Indicates whether the view access is constrained via Oracle Data Redaction.
- isAccess BooleanConstrained By Sql Firewall 
- Indicates whether the view access is constrained via Oracle Database SQL Firewall.
- isAccess BooleanConstrained By Virtual Private Database 
- 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.
- 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
- A filter to return only items related to a specific target OCID.
- viewName String
- The name of the view.
- viewSchema String
- The name of the schema.
- viewText String
- Definition of the view.
GetSecurityPolicyReportDatabaseViewAccessEntriesFilter        
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the ociTerraform Provider.