1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSecurityPolicyReportDatabaseTableAccessEntry
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

oci.DataSafe.getSecurityPolicyReportDatabaseTableAccessEntry

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

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

    Gets a database table access entry object by identifier.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testSecurityPolicyReportDatabaseTableAccessEntry = oci.DataSafe.getSecurityPolicyReportDatabaseTableAccessEntry({
        databaseTableAccessEntryKey: securityPolicyReportDatabaseTableAccessEntryDatabaseTableAccessEntryKey,
        securityPolicyReportId: testSecurityPolicyReport.id,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_security_policy_report_database_table_access_entry = oci.DataSafe.get_security_policy_report_database_table_access_entry(database_table_access_entry_key=security_policy_report_database_table_access_entry_database_table_access_entry_key,
        security_policy_report_id=test_security_policy_report["id"])
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/go/oci/DataSafe"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := DataSafe.GetSecurityPolicyReportDatabaseTableAccessEntry(ctx, &datasafe.GetSecurityPolicyReportDatabaseTableAccessEntryArgs{
    			DatabaseTableAccessEntryKey: securityPolicyReportDatabaseTableAccessEntryDatabaseTableAccessEntryKey,
    			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 testSecurityPolicyReportDatabaseTableAccessEntry = Oci.DataSafe.GetSecurityPolicyReportDatabaseTableAccessEntry.Invoke(new()
        {
            DatabaseTableAccessEntryKey = securityPolicyReportDatabaseTableAccessEntryDatabaseTableAccessEntryKey,
            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.GetSecurityPolicyReportDatabaseTableAccessEntryArgs;
    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 testSecurityPolicyReportDatabaseTableAccessEntry = DataSafeFunctions.getSecurityPolicyReportDatabaseTableAccessEntry(GetSecurityPolicyReportDatabaseTableAccessEntryArgs.builder()
                .databaseTableAccessEntryKey(securityPolicyReportDatabaseTableAccessEntryDatabaseTableAccessEntryKey)
                .securityPolicyReportId(testSecurityPolicyReport.id())
                .build());
    
        }
    }
    
    variables:
      testSecurityPolicyReportDatabaseTableAccessEntry:
        fn::invoke:
          Function: oci:DataSafe:getSecurityPolicyReportDatabaseTableAccessEntry
          Arguments:
            databaseTableAccessEntryKey: ${securityPolicyReportDatabaseTableAccessEntryDatabaseTableAccessEntryKey}
            securityPolicyReportId: ${testSecurityPolicyReport.id}
    

    Using getSecurityPolicyReportDatabaseTableAccessEntry

    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 getSecurityPolicyReportDatabaseTableAccessEntry(args: GetSecurityPolicyReportDatabaseTableAccessEntryArgs, opts?: InvokeOptions): Promise<GetSecurityPolicyReportDatabaseTableAccessEntryResult>
    function getSecurityPolicyReportDatabaseTableAccessEntryOutput(args: GetSecurityPolicyReportDatabaseTableAccessEntryOutputArgs, opts?: InvokeOptions): Output<GetSecurityPolicyReportDatabaseTableAccessEntryResult>
    def get_security_policy_report_database_table_access_entry(database_table_access_entry_key: Optional[str] = None,
                                                               security_policy_report_id: Optional[str] = None,
                                                               opts: Optional[InvokeOptions] = None) -> GetSecurityPolicyReportDatabaseTableAccessEntryResult
    def get_security_policy_report_database_table_access_entry_output(database_table_access_entry_key: Optional[pulumi.Input[str]] = None,
                                                               security_policy_report_id: Optional[pulumi.Input[str]] = None,
                                                               opts: Optional[InvokeOptions] = None) -> Output[GetSecurityPolicyReportDatabaseTableAccessEntryResult]
    func GetSecurityPolicyReportDatabaseTableAccessEntry(ctx *Context, args *GetSecurityPolicyReportDatabaseTableAccessEntryArgs, opts ...InvokeOption) (*GetSecurityPolicyReportDatabaseTableAccessEntryResult, error)
    func GetSecurityPolicyReportDatabaseTableAccessEntryOutput(ctx *Context, args *GetSecurityPolicyReportDatabaseTableAccessEntryOutputArgs, opts ...InvokeOption) GetSecurityPolicyReportDatabaseTableAccessEntryResultOutput

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

    public static class GetSecurityPolicyReportDatabaseTableAccessEntry 
    {
        public static Task<GetSecurityPolicyReportDatabaseTableAccessEntryResult> InvokeAsync(GetSecurityPolicyReportDatabaseTableAccessEntryArgs args, InvokeOptions? opts = null)
        public static Output<GetSecurityPolicyReportDatabaseTableAccessEntryResult> Invoke(GetSecurityPolicyReportDatabaseTableAccessEntryInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetSecurityPolicyReportDatabaseTableAccessEntryResult> getSecurityPolicyReportDatabaseTableAccessEntry(GetSecurityPolicyReportDatabaseTableAccessEntryArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DataSafe/getSecurityPolicyReportDatabaseTableAccessEntry:getSecurityPolicyReportDatabaseTableAccessEntry
      arguments:
        # arguments dictionary

    The following arguments are supported:

    DatabaseTableAccessEntryKey string
    The unique key that identifies the table access object. This is a system-generated identifier.
    SecurityPolicyReportId string
    The OCID of the security policy report resource.
    DatabaseTableAccessEntryKey string
    The unique key that identifies the table access object. This is a system-generated identifier.
    SecurityPolicyReportId string
    The OCID of the security policy report resource.
    databaseTableAccessEntryKey String
    The unique key that identifies the table access object. This is a system-generated identifier.
    securityPolicyReportId String
    The OCID of the security policy report resource.
    databaseTableAccessEntryKey string
    The unique key that identifies the table access object. This is a system-generated identifier.
    securityPolicyReportId string
    The OCID of the security policy report resource.
    database_table_access_entry_key str
    The unique key that identifies the table access object. This is a system-generated identifier.
    security_policy_report_id str
    The OCID of the security policy report resource.
    databaseTableAccessEntryKey String
    The unique key that identifies the table access object. This is a system-generated identifier.
    securityPolicyReportId String
    The OCID of the security policy report resource.

    getSecurityPolicyReportDatabaseTableAccessEntry Result

    The following output properties are available:

    AccessThroughObject string
    A non-null value in this field indicates the object through which user has access to table, possible values could be table or view.
    AccessType string
    The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT, OWNER or DELETE.
    AreAllTablesAccessible bool
    Indicates whether the user has access to all the tables in the schema.
    ColumnName string
    If there are column level privileges on a table or view.
    DatabaseTableAccessEntryKey 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
    Grantor string
    The one who granted this 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.
    IsAccessConstrainedByLabelSecurity bool
    Indicates whether the table access is constrained via Oracle Label Security.
    IsAccessConstrainedByRealApplicationSecurity bool
    Indicates whether the table access is constrained via Real Application Security.
    IsAccessConstrainedByRedaction bool
    Indicates whether the table access is constrained via Oracle Data Redaction.
    IsAccessConstrainedBySqlFirewall bool
    Indicates whether the table access is constrained via Oracle Database SQL Firewall.
    IsAccessConstrainedByView bool
    Indicates whether the access is constrained on a table via a view.
    IsAccessConstrainedByVirtualPrivateDatabase bool
    Indicates whether the table access is constrained via Virtual Private Database.
    IsSensitive bool
    Indicates whether the table is marked as sensitive.
    Key string
    The unique key that identifies the table access report. It is numeric and unique within a security policy report.
    Privilege string
    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.
    AccessThroughObject string
    A non-null value in this field indicates the object through which user has access to table, possible values could be table or view.
    AccessType string
    The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT, OWNER or DELETE.
    AreAllTablesAccessible bool
    Indicates whether the user has access to all the tables in the schema.
    ColumnName string
    If there are column level privileges on a table or view.
    DatabaseTableAccessEntryKey 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
    Grantor string
    The one who granted this 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.
    IsAccessConstrainedByLabelSecurity bool
    Indicates whether the table access is constrained via Oracle Label Security.
    IsAccessConstrainedByRealApplicationSecurity bool
    Indicates whether the table access is constrained via Real Application Security.
    IsAccessConstrainedByRedaction bool
    Indicates whether the table access is constrained via Oracle Data Redaction.
    IsAccessConstrainedBySqlFirewall bool
    Indicates whether the table access is constrained via Oracle Database SQL Firewall.
    IsAccessConstrainedByView bool
    Indicates whether the access is constrained on a table via a view.
    IsAccessConstrainedByVirtualPrivateDatabase bool
    Indicates whether the table access is constrained via Virtual Private Database.
    IsSensitive bool
    Indicates whether the table is marked as sensitive.
    Key string
    The unique key that identifies the table access report. It is numeric and unique within a security policy report.
    Privilege string
    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.
    accessThroughObject String
    A non-null value in this field indicates the object through which user has access to table, possible values could be table or view.
    accessType String
    The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT, OWNER or DELETE.
    areAllTablesAccessible Boolean
    Indicates whether the user has access to all the tables in the schema.
    columnName String
    If there are column level privileges on a table or view.
    databaseTableAccessEntryKey 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
    grantor String
    The one who granted this 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.
    isAccessConstrainedByLabelSecurity Boolean
    Indicates whether the table access is constrained via Oracle Label Security.
    isAccessConstrainedByRealApplicationSecurity Boolean
    Indicates whether the table access is constrained via Real Application Security.
    isAccessConstrainedByRedaction Boolean
    Indicates whether the table access is constrained via Oracle Data Redaction.
    isAccessConstrainedBySqlFirewall Boolean
    Indicates whether the table access is constrained via Oracle Database SQL Firewall.
    isAccessConstrainedByView Boolean
    Indicates whether the access is constrained on a table via a view.
    isAccessConstrainedByVirtualPrivateDatabase Boolean
    Indicates whether the table access is constrained via Virtual Private Database.
    isSensitive Boolean
    Indicates whether the table is marked as sensitive.
    key String
    The unique key that identifies the table access report. It is numeric and unique within a security policy report.
    privilege String
    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.
    accessThroughObject string
    A non-null value in this field indicates the object through which user has access to table, possible values could be table or view.
    accessType string
    The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT, OWNER or DELETE.
    areAllTablesAccessible boolean
    Indicates whether the user has access to all the tables in the schema.
    columnName string
    If there are column level privileges on a table or view.
    databaseTableAccessEntryKey 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
    grantor string
    The one who granted this 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.
    isAccessConstrainedByLabelSecurity boolean
    Indicates whether the table access is constrained via Oracle Label Security.
    isAccessConstrainedByRealApplicationSecurity boolean
    Indicates whether the table access is constrained via Real Application Security.
    isAccessConstrainedByRedaction boolean
    Indicates whether the table access is constrained via Oracle Data Redaction.
    isAccessConstrainedBySqlFirewall boolean
    Indicates whether the table access is constrained via Oracle Database SQL Firewall.
    isAccessConstrainedByView boolean
    Indicates whether the access is constrained on a table via a view.
    isAccessConstrainedByVirtualPrivateDatabase boolean
    Indicates whether the table access is constrained via Virtual Private Database.
    isSensitive boolean
    Indicates whether the table is marked as sensitive.
    key string
    The unique key that identifies the table access report. It is numeric and unique within a security policy report.
    privilege string
    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.
    access_through_object str
    A non-null value in this field indicates the object through which user has access to table, possible values could be table or 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, OWNER or DELETE.
    are_all_tables_accessible bool
    Indicates whether the user has access to all the tables in the schema.
    column_name str
    If there are column level privileges on a table or view.
    database_table_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
    grantor str
    The one who granted this 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_label_security bool
    Indicates whether the table access is constrained via Oracle Label Security.
    is_access_constrained_by_real_application_security bool
    Indicates whether the table access is constrained via Real Application Security.
    is_access_constrained_by_redaction bool
    Indicates whether the table access is constrained via Oracle Data Redaction.
    is_access_constrained_by_sql_firewall bool
    Indicates whether the table access is constrained via Oracle Database SQL Firewall.
    is_access_constrained_by_view bool
    Indicates whether the access is constrained on a table via a view.
    is_access_constrained_by_virtual_private_database bool
    Indicates whether the table access is constrained via Virtual Private Database.
    is_sensitive bool
    Indicates whether the table is marked as sensitive.
    key str
    The unique key that identifies the table access report. It is numeric and unique within a security policy report.
    privilege str
    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.
    accessThroughObject String
    A non-null value in this field indicates the object through which user has access to table, possible values could be table or view.
    accessType String
    The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT, OWNER or DELETE.
    areAllTablesAccessible Boolean
    Indicates whether the user has access to all the tables in the schema.
    columnName String
    If there are column level privileges on a table or view.
    databaseTableAccessEntryKey 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
    grantor String
    The one who granted this 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.
    isAccessConstrainedByLabelSecurity Boolean
    Indicates whether the table access is constrained via Oracle Label Security.
    isAccessConstrainedByRealApplicationSecurity Boolean
    Indicates whether the table access is constrained via Real Application Security.
    isAccessConstrainedByRedaction Boolean
    Indicates whether the table access is constrained via Oracle Data Redaction.
    isAccessConstrainedBySqlFirewall Boolean
    Indicates whether the table access is constrained via Oracle Database SQL Firewall.
    isAccessConstrainedByView Boolean
    Indicates whether the access is constrained on a table via a view.
    isAccessConstrainedByVirtualPrivateDatabase Boolean
    Indicates whether the table access is constrained via Virtual Private Database.
    isSensitive Boolean
    Indicates whether the table is marked as sensitive.
    key String
    The unique key that identifies the table access report. It is numeric and unique within a security policy report.
    privilege String
    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.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi