Oracle Cloud Infrastructure v1.32.0, Apr 18 24

Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi

oci.DataSafe.getUserAssessmentUsers

Explore with Pulumi AI

Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi

Gets a list of users of the specified user assessment. The result contains the database user details for each user, such as user type, account status, last login time, user creation time, authentication type, user profile, and the date and time of the latest password change. It also contains the user category derived from these user details as well as privileges granted to each user.

Example Usage

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

const testUserAssessmentUsers = oci.DataSafe.getUserAssessmentUsers({
    userAssessmentId: oci_data_safe_user_assessment.test_user_assessment.id,
    accessLevel: _var.user_assessment_user_access_level,
    accountStatus: _var.user_assessment_user_account_status,
    areAllSchemasAccessible: _var.user_assessment_user_are_all_schemas_accessible,
    authenticationType: _var.user_assessment_user_authentication_type,
    compartmentIdInSubtree: _var.user_assessment_user_compartment_id_in_subtree,
    schemaLists: _var.user_assessment_user_schema_list,
    targetId: oci_cloud_guard_target.test_target.id,
    timeLastLoginGreaterThanOrEqualTo: _var.user_assessment_user_time_last_login_greater_than_or_equal_to,
    timeLastLoginLessThan: _var.user_assessment_user_time_last_login_less_than,
    timePasswordLastChangedGreaterThanOrEqualTo: _var.user_assessment_user_time_password_last_changed_greater_than_or_equal_to,
    timePasswordLastChangedLessThan: _var.user_assessment_user_time_password_last_changed_less_than,
    timeUserCreatedGreaterThanOrEqualTo: _var.user_assessment_user_time_user_created_greater_than_or_equal_to,
    timeUserCreatedLessThan: _var.user_assessment_user_time_user_created_less_than,
    userCategory: _var.user_assessment_user_user_category,
    userKey: _var.user_assessment_user_user_key,
    userName: oci_identity_user.test_user.name,
    userProfile: _var.user_assessment_user_user_profile,
    userRole: _var.user_assessment_user_user_role,
    userType: _var.user_assessment_user_user_type,
});

import pulumi
import pulumi_oci as oci

test_user_assessment_users = oci.DataSafe.get_user_assessment_users(user_assessment_id=oci_data_safe_user_assessment["test_user_assessment"]["id"],
    access_level=var["user_assessment_user_access_level"],
    account_status=var["user_assessment_user_account_status"],
    are_all_schemas_accessible=var["user_assessment_user_are_all_schemas_accessible"],
    authentication_type=var["user_assessment_user_authentication_type"],
    compartment_id_in_subtree=var["user_assessment_user_compartment_id_in_subtree"],
    schema_lists=var["user_assessment_user_schema_list"],
    target_id=oci_cloud_guard_target["test_target"]["id"],
    time_last_login_greater_than_or_equal_to=var["user_assessment_user_time_last_login_greater_than_or_equal_to"],
    time_last_login_less_than=var["user_assessment_user_time_last_login_less_than"],
    time_password_last_changed_greater_than_or_equal_to=var["user_assessment_user_time_password_last_changed_greater_than_or_equal_to"],
    time_password_last_changed_less_than=var["user_assessment_user_time_password_last_changed_less_than"],
    time_user_created_greater_than_or_equal_to=var["user_assessment_user_time_user_created_greater_than_or_equal_to"],
    time_user_created_less_than=var["user_assessment_user_time_user_created_less_than"],
    user_category=var["user_assessment_user_user_category"],
    user_key=var["user_assessment_user_user_key"],
    user_name=oci_identity_user["test_user"]["name"],
    user_profile=var["user_assessment_user_user_profile"],
    user_role=var["user_assessment_user_user_role"],
    user_type=var["user_assessment_user_user_type"])

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.GetUserAssessmentUsers(ctx, &datasafe.GetUserAssessmentUsersArgs{
			UserAssessmentId:                  oci_data_safe_user_assessment.Test_user_assessment.Id,
			AccessLevel:                       pulumi.StringRef(_var.User_assessment_user_access_level),
			AccountStatus:                     pulumi.StringRef(_var.User_assessment_user_account_status),
			AreAllSchemasAccessible:           pulumi.BoolRef(_var.User_assessment_user_are_all_schemas_accessible),
			AuthenticationType:                pulumi.StringRef(_var.User_assessment_user_authentication_type),
			CompartmentIdInSubtree:            pulumi.BoolRef(_var.User_assessment_user_compartment_id_in_subtree),
			SchemaLists:                       _var.User_assessment_user_schema_list,
			TargetId:                          pulumi.StringRef(oci_cloud_guard_target.Test_target.Id),
			TimeLastLoginGreaterThanOrEqualTo: pulumi.StringRef(_var.User_assessment_user_time_last_login_greater_than_or_equal_to),
			TimeLastLoginLessThan:             pulumi.StringRef(_var.User_assessment_user_time_last_login_less_than),
			TimePasswordLastChangedGreaterThanOrEqualTo: pulumi.StringRef(_var.User_assessment_user_time_password_last_changed_greater_than_or_equal_to),
			TimePasswordLastChangedLessThan:             pulumi.StringRef(_var.User_assessment_user_time_password_last_changed_less_than),
			TimeUserCreatedGreaterThanOrEqualTo:         pulumi.StringRef(_var.User_assessment_user_time_user_created_greater_than_or_equal_to),
			TimeUserCreatedLessThan:                     pulumi.StringRef(_var.User_assessment_user_time_user_created_less_than),
			UserCategory:                                pulumi.StringRef(_var.User_assessment_user_user_category),
			UserKey:                                     pulumi.StringRef(_var.User_assessment_user_user_key),
			UserName:                                    pulumi.StringRef(oci_identity_user.Test_user.Name),
			UserProfile:                                 pulumi.StringRef(_var.User_assessment_user_user_profile),
			UserRole:                                    pulumi.StringRef(_var.User_assessment_user_user_role),
			UserType:                                    pulumi.StringRef(_var.User_assessment_user_user_type),
		}, 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 testUserAssessmentUsers = Oci.DataSafe.GetUserAssessmentUsers.Invoke(new()
    {
        UserAssessmentId = oci_data_safe_user_assessment.Test_user_assessment.Id,
        AccessLevel = @var.User_assessment_user_access_level,
        AccountStatus = @var.User_assessment_user_account_status,
        AreAllSchemasAccessible = @var.User_assessment_user_are_all_schemas_accessible,
        AuthenticationType = @var.User_assessment_user_authentication_type,
        CompartmentIdInSubtree = @var.User_assessment_user_compartment_id_in_subtree,
        SchemaLists = @var.User_assessment_user_schema_list,
        TargetId = oci_cloud_guard_target.Test_target.Id,
        TimeLastLoginGreaterThanOrEqualTo = @var.User_assessment_user_time_last_login_greater_than_or_equal_to,
        TimeLastLoginLessThan = @var.User_assessment_user_time_last_login_less_than,
        TimePasswordLastChangedGreaterThanOrEqualTo = @var.User_assessment_user_time_password_last_changed_greater_than_or_equal_to,
        TimePasswordLastChangedLessThan = @var.User_assessment_user_time_password_last_changed_less_than,
        TimeUserCreatedGreaterThanOrEqualTo = @var.User_assessment_user_time_user_created_greater_than_or_equal_to,
        TimeUserCreatedLessThan = @var.User_assessment_user_time_user_created_less_than,
        UserCategory = @var.User_assessment_user_user_category,
        UserKey = @var.User_assessment_user_user_key,
        UserName = oci_identity_user.Test_user.Name,
        UserProfile = @var.User_assessment_user_user_profile,
        UserRole = @var.User_assessment_user_user_role,
        UserType = @var.User_assessment_user_user_type,
    });

});

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.GetUserAssessmentUsersArgs;
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 testUserAssessmentUsers = DataSafeFunctions.getUserAssessmentUsers(GetUserAssessmentUsersArgs.builder()
            .userAssessmentId(oci_data_safe_user_assessment.test_user_assessment().id())
            .accessLevel(var_.user_assessment_user_access_level())
            .accountStatus(var_.user_assessment_user_account_status())
            .areAllSchemasAccessible(var_.user_assessment_user_are_all_schemas_accessible())
            .authenticationType(var_.user_assessment_user_authentication_type())
            .compartmentIdInSubtree(var_.user_assessment_user_compartment_id_in_subtree())
            .schemaLists(var_.user_assessment_user_schema_list())
            .targetId(oci_cloud_guard_target.test_target().id())
            .timeLastLoginGreaterThanOrEqualTo(var_.user_assessment_user_time_last_login_greater_than_or_equal_to())
            .timeLastLoginLessThan(var_.user_assessment_user_time_last_login_less_than())
            .timePasswordLastChangedGreaterThanOrEqualTo(var_.user_assessment_user_time_password_last_changed_greater_than_or_equal_to())
            .timePasswordLastChangedLessThan(var_.user_assessment_user_time_password_last_changed_less_than())
            .timeUserCreatedGreaterThanOrEqualTo(var_.user_assessment_user_time_user_created_greater_than_or_equal_to())
            .timeUserCreatedLessThan(var_.user_assessment_user_time_user_created_less_than())
            .userCategory(var_.user_assessment_user_user_category())
            .userKey(var_.user_assessment_user_user_key())
            .userName(oci_identity_user.test_user().name())
            .userProfile(var_.user_assessment_user_user_profile())
            .userRole(var_.user_assessment_user_user_role())
            .userType(var_.user_assessment_user_user_type())
            .build());

    }
}

variables:
  testUserAssessmentUsers:
    fn::invoke:
      Function: oci:DataSafe:getUserAssessmentUsers
      Arguments:
        userAssessmentId: ${oci_data_safe_user_assessment.test_user_assessment.id}
        accessLevel: ${var.user_assessment_user_access_level}
        accountStatus: ${var.user_assessment_user_account_status}
        areAllSchemasAccessible: ${var.user_assessment_user_are_all_schemas_accessible}
        authenticationType: ${var.user_assessment_user_authentication_type}
        compartmentIdInSubtree: ${var.user_assessment_user_compartment_id_in_subtree}
        schemaLists: ${var.user_assessment_user_schema_list}
        targetId: ${oci_cloud_guard_target.test_target.id}
        timeLastLoginGreaterThanOrEqualTo: ${var.user_assessment_user_time_last_login_greater_than_or_equal_to}
        timeLastLoginLessThan: ${var.user_assessment_user_time_last_login_less_than}
        timePasswordLastChangedGreaterThanOrEqualTo: ${var.user_assessment_user_time_password_last_changed_greater_than_or_equal_to}
        timePasswordLastChangedLessThan: ${var.user_assessment_user_time_password_last_changed_less_than}
        timeUserCreatedGreaterThanOrEqualTo: ${var.user_assessment_user_time_user_created_greater_than_or_equal_to}
        timeUserCreatedLessThan: ${var.user_assessment_user_time_user_created_less_than}
        userCategory: ${var.user_assessment_user_user_category}
        userKey: ${var.user_assessment_user_user_key}
        userName: ${oci_identity_user.test_user.name}
        userProfile: ${var.user_assessment_user_user_profile}
        userRole: ${var.user_assessment_user_user_role}
        userType: ${var.user_assessment_user_user_type}

Using getUserAssessmentUsers

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 getUserAssessmentUsers(args: GetUserAssessmentUsersArgs, opts?: InvokeOptions): Promise<GetUserAssessmentUsersResult>
function getUserAssessmentUsersOutput(args: GetUserAssessmentUsersOutputArgs, opts?: InvokeOptions): Output<GetUserAssessmentUsersResult>

def get_user_assessment_users(access_level: Optional[str] = None,
                              account_status: Optional[str] = None,
                              are_all_schemas_accessible: Optional[bool] = None,
                              authentication_type: Optional[str] = None,
                              compartment_id_in_subtree: Optional[bool] = None,
                              filters: Optional[Sequence[_datasafe.GetUserAssessmentUsersFilter]] = None,
                              schema_lists: Optional[Sequence[str]] = None,
                              target_id: Optional[str] = None,
                              time_last_login_greater_than_or_equal_to: Optional[str] = None,
                              time_last_login_less_than: Optional[str] = None,
                              time_password_last_changed_greater_than_or_equal_to: Optional[str] = None,
                              time_password_last_changed_less_than: Optional[str] = None,
                              time_user_created_greater_than_or_equal_to: Optional[str] = None,
                              time_user_created_less_than: Optional[str] = None,
                              user_assessment_id: Optional[str] = None,
                              user_category: Optional[str] = None,
                              user_key: Optional[str] = None,
                              user_name: Optional[str] = None,
                              user_profile: Optional[str] = None,
                              user_role: Optional[str] = None,
                              user_type: Optional[str] = None,
                              opts: Optional[InvokeOptions] = None) -> GetUserAssessmentUsersResult
def get_user_assessment_users_output(access_level: Optional[pulumi.Input[str]] = None,
                              account_status: Optional[pulumi.Input[str]] = None,
                              are_all_schemas_accessible: Optional[pulumi.Input[bool]] = None,
                              authentication_type: Optional[pulumi.Input[str]] = None,
                              compartment_id_in_subtree: Optional[pulumi.Input[bool]] = None,
                              filters: Optional[pulumi.Input[Sequence[pulumi.Input[_datasafe.GetUserAssessmentUsersFilterArgs]]]] = None,
                              schema_lists: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                              target_id: Optional[pulumi.Input[str]] = None,
                              time_last_login_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                              time_last_login_less_than: Optional[pulumi.Input[str]] = None,
                              time_password_last_changed_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                              time_password_last_changed_less_than: Optional[pulumi.Input[str]] = None,
                              time_user_created_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                              time_user_created_less_than: Optional[pulumi.Input[str]] = None,
                              user_assessment_id: Optional[pulumi.Input[str]] = None,
                              user_category: Optional[pulumi.Input[str]] = None,
                              user_key: Optional[pulumi.Input[str]] = None,
                              user_name: Optional[pulumi.Input[str]] = None,
                              user_profile: Optional[pulumi.Input[str]] = None,
                              user_role: Optional[pulumi.Input[str]] = None,
                              user_type: Optional[pulumi.Input[str]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetUserAssessmentUsersResult]

func GetUserAssessmentUsers(ctx *Context, args *GetUserAssessmentUsersArgs, opts ...InvokeOption) (*GetUserAssessmentUsersResult, error)
func GetUserAssessmentUsersOutput(ctx *Context, args *GetUserAssessmentUsersOutputArgs, opts ...InvokeOption) GetUserAssessmentUsersResultOutput

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

public static class GetUserAssessmentUsers 
{
    public static Task<GetUserAssessmentUsersResult> InvokeAsync(GetUserAssessmentUsersArgs args, InvokeOptions? opts = null)
    public static Output<GetUserAssessmentUsersResult> Invoke(GetUserAssessmentUsersInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetUserAssessmentUsersResult> getUserAssessmentUsers(GetUserAssessmentUsersArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

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

The following arguments are supported:

UserAssessmentId string

The OCID of the user assessment.

AccessLevel string

Valid values are RESTRICTED and ACCESSIBLE. Default is RESTRICTED. Setting this to ACCESSIBLE returns only those compartments for which the user has INSPECT permissions directly or indirectly (permissions can be on a resource in a subcompartment). When set to RESTRICTED permissions are checked and no partial results are displayed.

AccountStatus string

A filter to return only items that match the specified account status.

AreAllSchemasAccessible bool

A filter to return only items that match the criteria that all schemas can be accessed by a user.

AuthenticationType string

A filter to return only items that match the specified authentication type.

CompartmentIdInSubtree bool

Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.

Filters List<GetUserAssessmentUsersFilter>

SchemaLists List<string>

A filter to return items that contain the specified schema list.

TargetId string

A filter to return only items related to a specific target OCID.

TimeLastLoginGreaterThanOrEqualTo string

A filter to return users whose last login time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

TimeLastLoginLessThan string

A filter to return users whose last login time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

TimePasswordLastChangedGreaterThanOrEqualTo string

A filter to return users whose last password change in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

TimePasswordLastChangedLessThan string

A filter to return users whose last password change in the database is less than the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

TimeUserCreatedGreaterThanOrEqualTo string

A filter to return users whose creation time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

TimeUserCreatedLessThan string

A filter to return users whose creation time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

UserCategory string

A filter to return only items that match the specified user category.

UserKey string

A filter to return only items that match the specified user key.

UserName string

A filter to return only items that match the specified user name.

UserProfile string

A filter to return only items that match the specified user profile.

UserRole string

A filter to return only items that match the specified user role.

UserType string

A filter to return only items that match the specified user type. The possible values can be

ADMIN_PRIVILEGED
APPLICATION
PRIVILEGED
SCHEMA
NON_PRIVILEGED as specified by '#/definitions/userTypes'.

UserAssessmentId string

The OCID of the user assessment.

AccessLevel string

AccountStatus string

A filter to return only items that match the specified account status.

AreAllSchemasAccessible bool

A filter to return only items that match the criteria that all schemas can be accessed by a user.

AuthenticationType string

A filter to return only items that match the specified authentication type.

CompartmentIdInSubtree bool

Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.

Filters []GetUserAssessmentUsersFilter

SchemaLists []string

A filter to return items that contain the specified schema list.

TargetId string

A filter to return only items related to a specific target OCID.

TimeLastLoginGreaterThanOrEqualTo string

A filter to return users whose last login time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

TimeLastLoginLessThan string

A filter to return users whose last login time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

TimePasswordLastChangedGreaterThanOrEqualTo string

A filter to return users whose last password change in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

TimePasswordLastChangedLessThan string

A filter to return users whose last password change in the database is less than the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

TimeUserCreatedGreaterThanOrEqualTo string

A filter to return users whose creation time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

TimeUserCreatedLessThan string

A filter to return users whose creation time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

UserCategory string

A filter to return only items that match the specified user category.

UserKey string

A filter to return only items that match the specified user key.

UserName string

A filter to return only items that match the specified user name.

UserProfile string

A filter to return only items that match the specified user profile.

UserRole string

A filter to return only items that match the specified user role.

UserType string

A filter to return only items that match the specified user type. The possible values can be

ADMIN_PRIVILEGED
APPLICATION
PRIVILEGED
SCHEMA
NON_PRIVILEGED as specified by '#/definitions/userTypes'.

userAssessmentId String

The OCID of the user assessment.

accessLevel String

accountStatus String

A filter to return only items that match the specified account status.

areAllSchemasAccessible Boolean

A filter to return only items that match the criteria that all schemas can be accessed by a user.

authenticationType String

A filter to return only items that match the specified authentication type.

compartmentIdInSubtree Boolean

Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.

filters List<GetUserAssessmentUsersFilter>

schemaLists List<String>

A filter to return items that contain the specified schema list.

targetId String

A filter to return only items related to a specific target OCID.

timeLastLoginGreaterThanOrEqualTo String

A filter to return users whose last login time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timeLastLoginLessThan String

A filter to return users whose last login time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

timePasswordLastChangedGreaterThanOrEqualTo String

A filter to return users whose last password change in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timePasswordLastChangedLessThan String

A filter to return users whose last password change in the database is less than the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timeUserCreatedGreaterThanOrEqualTo String

A filter to return users whose creation time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

timeUserCreatedLessThan String

A filter to return users whose creation time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

userCategory String

A filter to return only items that match the specified user category.

userKey String

A filter to return only items that match the specified user key.

userName String

A filter to return only items that match the specified user name.

userProfile String

A filter to return only items that match the specified user profile.

userRole String

A filter to return only items that match the specified user role.

userType String

A filter to return only items that match the specified user type. The possible values can be

ADMIN_PRIVILEGED
APPLICATION
PRIVILEGED
SCHEMA
NON_PRIVILEGED as specified by '#/definitions/userTypes'.

userAssessmentId string

The OCID of the user assessment.

accessLevel string

accountStatus string

A filter to return only items that match the specified account status.

areAllSchemasAccessible boolean

A filter to return only items that match the criteria that all schemas can be accessed by a user.

authenticationType string

A filter to return only items that match the specified authentication type.

compartmentIdInSubtree boolean

Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.

filters GetUserAssessmentUsersFilter[]

schemaLists string[]

A filter to return items that contain the specified schema list.

targetId string

A filter to return only items related to a specific target OCID.

timeLastLoginGreaterThanOrEqualTo string

A filter to return users whose last login time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timeLastLoginLessThan string

A filter to return users whose last login time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

timePasswordLastChangedGreaterThanOrEqualTo string

A filter to return users whose last password change in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timePasswordLastChangedLessThan string

A filter to return users whose last password change in the database is less than the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timeUserCreatedGreaterThanOrEqualTo string

A filter to return users whose creation time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

timeUserCreatedLessThan string

A filter to return users whose creation time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

userCategory string

A filter to return only items that match the specified user category.

userKey string

A filter to return only items that match the specified user key.

userName string

A filter to return only items that match the specified user name.

userProfile string

A filter to return only items that match the specified user profile.

userRole string

A filter to return only items that match the specified user role.

userType string

A filter to return only items that match the specified user type. The possible values can be

ADMIN_PRIVILEGED
APPLICATION
PRIVILEGED
SCHEMA
NON_PRIVILEGED as specified by '#/definitions/userTypes'.

user_assessment_id str

The OCID of the user assessment.

access_level str

account_status str

A filter to return only items that match the specified account status.

are_all_schemas_accessible bool

A filter to return only items that match the criteria that all schemas can be accessed by a user.

authentication_type str

A filter to return only items that match the specified authentication type.

compartment_id_in_subtree bool

Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.

filters Sequence[datasafe.GetUserAssessmentUsersFilter]

schema_lists Sequence[str]

A filter to return items that contain the specified schema list.

target_id str

A filter to return only items related to a specific target OCID.

time_last_login_greater_than_or_equal_to str

A filter to return users whose last login time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

time_last_login_less_than str

A filter to return users whose last login time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

time_password_last_changed_greater_than_or_equal_to str

A filter to return users whose last password change in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

time_password_last_changed_less_than str

A filter to return users whose last password change in the database is less than the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

time_user_created_greater_than_or_equal_to str

A filter to return users whose creation time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

time_user_created_less_than str

A filter to return users whose creation time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

user_category str

A filter to return only items that match the specified user category.

user_key str

A filter to return only items that match the specified user key.

user_name str

A filter to return only items that match the specified user name.

user_profile str

A filter to return only items that match the specified user profile.

user_role str

A filter to return only items that match the specified user role.

user_type str

A filter to return only items that match the specified user type. The possible values can be

ADMIN_PRIVILEGED
APPLICATION
PRIVILEGED
SCHEMA
NON_PRIVILEGED as specified by '#/definitions/userTypes'.

userAssessmentId String

The OCID of the user assessment.

accessLevel String

accountStatus String

A filter to return only items that match the specified account status.

areAllSchemasAccessible Boolean

A filter to return only items that match the criteria that all schemas can be accessed by a user.

authenticationType String

A filter to return only items that match the specified authentication type.

compartmentIdInSubtree Boolean

Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.

filters List<Property Map>

schemaLists List<String>

A filter to return items that contain the specified schema list.

targetId String

A filter to return only items related to a specific target OCID.

timeLastLoginGreaterThanOrEqualTo String

A filter to return users whose last login time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timeLastLoginLessThan String

A filter to return users whose last login time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

timePasswordLastChangedGreaterThanOrEqualTo String

A filter to return users whose last password change in the database is greater than or equal to the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timePasswordLastChangedLessThan String

A filter to return users whose last password change in the database is less than the date and time specified, in the format defined by RFC3339.

Example: 2016-12-19T16:39:57.600Z

timeUserCreatedGreaterThanOrEqualTo String

A filter to return users whose creation time in the database is greater than or equal to the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

timeUserCreatedLessThan String

A filter to return users whose creation time in the database is less than the date and time specified, in the format defined by RFC3339. Example: 2016-12-19T16:39:57.600Z

userCategory String

A filter to return only items that match the specified user category.

userKey String

A filter to return only items that match the specified user key.

userName String

A filter to return only items that match the specified user name.

userProfile String

A filter to return only items that match the specified user profile.

userRole String

A filter to return only items that match the specified user role.

userType String

A filter to return only items that match the specified user type. The possible values can be

ADMIN_PRIVILEGED
APPLICATION
PRIVILEGED
SCHEMA
NON_PRIVILEGED as specified by '#/definitions/userTypes'.

getUserAssessmentUsers Result

The following output properties are available:

Id string: The provider-assigned unique ID for this managed resource.
UserAssessmentId string
Users List<GetUserAssessmentUsersUser>: The list of users.
AccessLevel string
AccountStatus string: The status of the user account.
AreAllSchemasAccessible bool: Indicates whether the user has access to all the schemas.
AuthenticationType string: The user authentication method.
CompartmentIdInSubtree bool
Filters List<GetUserAssessmentUsersFilter>
SchemaLists List<string>: The list of database schemas current user can access.
TargetId string: The OCID of the target database.
TimeLastLoginGreaterThanOrEqualTo string
TimeLastLoginLessThan string
TimePasswordLastChangedGreaterThanOrEqualTo string
TimePasswordLastChangedLessThan string
TimeUserCreatedGreaterThanOrEqualTo string
TimeUserCreatedLessThan string
UserCategory string: The user category based on the privileges and other details of the user.
UserKey string
UserName string: The database user name.
UserProfile string: The user profile name.
UserRole string
UserType string

Id string: The provider-assigned unique ID for this managed resource.
UserAssessmentId string
Users []GetUserAssessmentUsersUser: The list of users.
AccessLevel string
AccountStatus string: The status of the user account.
AreAllSchemasAccessible bool: Indicates whether the user has access to all the schemas.
AuthenticationType string: The user authentication method.
CompartmentIdInSubtree bool
Filters []GetUserAssessmentUsersFilter
SchemaLists []string: The list of database schemas current user can access.
TargetId string: The OCID of the target database.
TimeLastLoginGreaterThanOrEqualTo string
TimeLastLoginLessThan string
TimePasswordLastChangedGreaterThanOrEqualTo string
TimePasswordLastChangedLessThan string
TimeUserCreatedGreaterThanOrEqualTo string
TimeUserCreatedLessThan string
UserCategory string: The user category based on the privileges and other details of the user.
UserKey string
UserName string: The database user name.
UserProfile string: The user profile name.
UserRole string
UserType string

id String: The provider-assigned unique ID for this managed resource.
userAssessmentId String
users List<GetUserAssessmentUsersUser>: The list of users.
accessLevel String
accountStatus String: The status of the user account.
areAllSchemasAccessible Boolean: Indicates whether the user has access to all the schemas.
authenticationType String: The user authentication method.
compartmentIdInSubtree Boolean
filters List<GetUserAssessmentUsersFilter>
schemaLists List<String>: The list of database schemas current user can access.
targetId String: The OCID of the target database.
timeLastLoginGreaterThanOrEqualTo String
timeLastLoginLessThan String
timePasswordLastChangedGreaterThanOrEqualTo String
timePasswordLastChangedLessThan String
timeUserCreatedGreaterThanOrEqualTo String
timeUserCreatedLessThan String
userCategory String: The user category based on the privileges and other details of the user.
userKey String
userName String: The database user name.
userProfile String: The user profile name.
userRole String
userType String

id string: The provider-assigned unique ID for this managed resource.
userAssessmentId string
users GetUserAssessmentUsersUser[]: The list of users.
accessLevel string
accountStatus string: The status of the user account.
areAllSchemasAccessible boolean: Indicates whether the user has access to all the schemas.
authenticationType string: The user authentication method.
compartmentIdInSubtree boolean
filters GetUserAssessmentUsersFilter[]
schemaLists string[]: The list of database schemas current user can access.
targetId string: The OCID of the target database.
timeLastLoginGreaterThanOrEqualTo string
timeLastLoginLessThan string
timePasswordLastChangedGreaterThanOrEqualTo string
timePasswordLastChangedLessThan string
timeUserCreatedGreaterThanOrEqualTo string
timeUserCreatedLessThan string
userCategory string: The user category based on the privileges and other details of the user.
userKey string
userName string: The database user name.
userProfile string: The user profile name.
userRole string
userType string

id str: The provider-assigned unique ID for this managed resource.
user_assessment_id str
users Sequence[datasafe.GetUserAssessmentUsersUser]: The list of users.
access_level str
account_status str: The status of the user account.
are_all_schemas_accessible bool: Indicates whether the user has access to all the schemas.
authentication_type str: The user authentication method.
compartment_id_in_subtree bool
filters Sequence[datasafe.GetUserAssessmentUsersFilter]
schema_lists Sequence[str]: The list of database schemas current user can access.
target_id str: The OCID of the target database.
time_last_login_greater_than_or_equal_to str
time_last_login_less_than str
time_password_last_changed_greater_than_or_equal_to str
time_password_last_changed_less_than str
time_user_created_greater_than_or_equal_to str
time_user_created_less_than str
user_category str: The user category based on the privileges and other details of the user.
user_key str
user_name str: The database user name.
user_profile str: The user profile name.
user_role str
user_type str

id String: The provider-assigned unique ID for this managed resource.
userAssessmentId String
users List<Property Map>: The list of users.
accessLevel String
accountStatus String: The status of the user account.
areAllSchemasAccessible Boolean: Indicates whether the user has access to all the schemas.
authenticationType String: The user authentication method.
compartmentIdInSubtree Boolean
filters List<Property Map>
schemaLists List<String>: The list of database schemas current user can access.
targetId String: The OCID of the target database.
timeLastLoginGreaterThanOrEqualTo String
timeLastLoginLessThan String
timePasswordLastChangedGreaterThanOrEqualTo String
timePasswordLastChangedLessThan String
timeUserCreatedGreaterThanOrEqualTo String
timeUserCreatedLessThan String
userCategory String: The user category based on the privileges and other details of the user.
userKey String
userName String: The database user name.
userProfile String: The user profile name.
userRole String
userType String

Supporting Types

GetUserAssessmentUsersFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

GetUserAssessmentUsersUser

AccountStatus string: A filter to return only items that match the specified account status.
AdminRoles List<string>: The admin roles granted to the user.
AreAllSchemasAccessible bool: A filter to return only items that match the criteria that all schemas can be accessed by a user.
AuthenticationType string: A filter to return only items that match the specified authentication type.
Key string: The unique user key. This is a system-generated identifier. Use ListUsers to get the user key for a user.
SchemaLists List<string>: A filter to return items that contain the specified schema list.
TargetId string: A filter to return only items related to a specific target OCID.
TimeLastLogin string: The date and time the user last logged in, in the format defined by RFC3339.
TimePasswordChanged string: The date and time the user password was last changed, in the format defined by RFC3339.
TimeUserCreated string: The date and time the user was created in the database, in the format defined by RFC3339.
UserCategory string: A filter to return only items that match the specified user category.
UserName string: A filter to return only items that match the specified user name.
UserProfile string: A filter to return only items that match the specified user profile.
UserTypes List<string>: The user type, which can be a combination of the following:

AccountStatus string: A filter to return only items that match the specified account status.
AdminRoles []string: The admin roles granted to the user.
AreAllSchemasAccessible bool: A filter to return only items that match the criteria that all schemas can be accessed by a user.
AuthenticationType string: A filter to return only items that match the specified authentication type.
Key string: The unique user key. This is a system-generated identifier. Use ListUsers to get the user key for a user.
SchemaLists []string: A filter to return items that contain the specified schema list.
TargetId string: A filter to return only items related to a specific target OCID.
TimeLastLogin string: The date and time the user last logged in, in the format defined by RFC3339.
TimePasswordChanged string: The date and time the user password was last changed, in the format defined by RFC3339.
TimeUserCreated string: The date and time the user was created in the database, in the format defined by RFC3339.
UserCategory string: A filter to return only items that match the specified user category.
UserName string: A filter to return only items that match the specified user name.
UserProfile string: A filter to return only items that match the specified user profile.
UserTypes []string: The user type, which can be a combination of the following:

accountStatus String: A filter to return only items that match the specified account status.
adminRoles List<String>: The admin roles granted to the user.
areAllSchemasAccessible Boolean: A filter to return only items that match the criteria that all schemas can be accessed by a user.
authenticationType String: A filter to return only items that match the specified authentication type.
key String: The unique user key. This is a system-generated identifier. Use ListUsers to get the user key for a user.
schemaLists List<String>: A filter to return items that contain the specified schema list.
targetId String: A filter to return only items related to a specific target OCID.
timeLastLogin String: The date and time the user last logged in, in the format defined by RFC3339.
timePasswordChanged String: The date and time the user password was last changed, in the format defined by RFC3339.
timeUserCreated String: The date and time the user was created in the database, in the format defined by RFC3339.
userCategory String: A filter to return only items that match the specified user category.
userName String: A filter to return only items that match the specified user name.
userProfile String: A filter to return only items that match the specified user profile.
userTypes List<String>: The user type, which can be a combination of the following:

accountStatus string: A filter to return only items that match the specified account status.
adminRoles string[]: The admin roles granted to the user.
areAllSchemasAccessible boolean: A filter to return only items that match the criteria that all schemas can be accessed by a user.
authenticationType string: A filter to return only items that match the specified authentication type.
key string: The unique user key. This is a system-generated identifier. Use ListUsers to get the user key for a user.
schemaLists string[]: A filter to return items that contain the specified schema list.
targetId string: A filter to return only items related to a specific target OCID.
timeLastLogin string: The date and time the user last logged in, in the format defined by RFC3339.
timePasswordChanged string: The date and time the user password was last changed, in the format defined by RFC3339.
timeUserCreated string: The date and time the user was created in the database, in the format defined by RFC3339.
userCategory string: A filter to return only items that match the specified user category.
userName string: A filter to return only items that match the specified user name.
userProfile string: A filter to return only items that match the specified user profile.
userTypes string[]: The user type, which can be a combination of the following:

account_status str: A filter to return only items that match the specified account status.
admin_roles Sequence[str]: The admin roles granted to the user.
are_all_schemas_accessible bool: A filter to return only items that match the criteria that all schemas can be accessed by a user.
authentication_type str: A filter to return only items that match the specified authentication type.
key str: The unique user key. This is a system-generated identifier. Use ListUsers to get the user key for a user.
schema_lists Sequence[str]: A filter to return items that contain the specified schema list.
target_id str: A filter to return only items related to a specific target OCID.
time_last_login str: The date and time the user last logged in, in the format defined by RFC3339.
time_password_changed str: The date and time the user password was last changed, in the format defined by RFC3339.
time_user_created str: The date and time the user was created in the database, in the format defined by RFC3339.
user_category str: A filter to return only items that match the specified user category.
user_name str: A filter to return only items that match the specified user name.
user_profile str: A filter to return only items that match the specified user profile.
user_types Sequence[str]: The user type, which can be a combination of the following:

accountStatus String: A filter to return only items that match the specified account status.
adminRoles List<String>: The admin roles granted to the user.
areAllSchemasAccessible Boolean: A filter to return only items that match the criteria that all schemas can be accessed by a user.
authenticationType String: A filter to return only items that match the specified authentication type.
key String: The unique user key. This is a system-generated identifier. Use ListUsers to get the user key for a user.
schemaLists List<String>: A filter to return items that contain the specified schema list.
targetId String: A filter to return only items related to a specific target OCID.
timeLastLogin String: The date and time the user last logged in, in the format defined by RFC3339.
timePasswordChanged String: The date and time the user password was last changed, in the format defined by RFC3339.
timeUserCreated String: The date and time the user was created in the database, in the format defined by RFC3339.
userCategory String: A filter to return only items that match the specified user category.
userName String: A filter to return only items that match the specified user name.
userProfile String: A filter to return only items that match the specified user profile.
userTypes List<String>: The user type, which can be a combination of the following:

Package Details

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

Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi

pulumi/pulumi-oci

oci.DataSafe.getUserAssessmentUsers

On this page

On this page

Example Usage

Using getUserAssessmentUsers

getUserAssessmentUsers Result

Supporting Types

GetUserAssessmentUsersFilter

GetUserAssessmentUsersUser

Package Details

On this page

On this page