User¶

class oci.database_management.models.User(**kwargs)¶

Bases: object

The summary of a specific user resource.

Attributes

`ALL_SHARED_NO`	A constant which can be used with the all_shared property of a User.
`ALL_SHARED_YES`	A constant which can be used with the all_shared property of a User.
`AUTHENTICATION_EXTERNAL`	A constant which can be used with the authentication property of a User.
`AUTHENTICATION_GLOBAL`	A constant which can be used with the authentication property of a User.
`AUTHENTICATION_NONE`	A constant which can be used with the authentication property of a User.
`AUTHENTICATION_PASSWORD`	A constant which can be used with the authentication property of a User.
`COMMON_NO`	A constant which can be used with the common property of a User.
`COMMON_YES`	A constant which can be used with the common property of a User.
`EDITIONS_ENABLED_NO`	A constant which can be used with the editions_enabled property of a User.
`EDITIONS_ENABLED_YES`	A constant which can be used with the editions_enabled property of a User.
`EXTERNAL_SHARED_NO`	A constant which can be used with the external_shared property of a User.
`EXTERNAL_SHARED_YES`	A constant which can be used with the external_shared property of a User.
`IMPLICIT_NO`	A constant which can be used with the implicit property of a User.
`IMPLICIT_YES`	A constant which can be used with the implicit property of a User.
`INHERITED_NO`	A constant which can be used with the inherited property of a User.
`INHERITED_YES`	A constant which can be used with the inherited property of a User.
`ORACLE_MAINTAINED_NO`	A constant which can be used with the oracle_maintained property of a User.
`ORACLE_MAINTAINED_YES`	A constant which can be used with the oracle_maintained property of a User.
`PROXY_CONNECT_NO`	A constant which can be used with the proxy_connect property of a User.
`PROXY_CONNECT_YES`	A constant which can be used with the proxy_connect property of a User.
`STATUS_EXPIRED`	A constant which can be used with the status property of a User.
`STATUS_EXPIRED_AND_IN_ROLLOVER`	A constant which can be used with the status property of a User.
`STATUS_EXPIRED_AND_LOCKED`	A constant which can be used with the status property of a User.
`STATUS_EXPIRED_AND_LOCKED_AND_IN_ROLLOVER`	A constant which can be used with the status property of a User.
`STATUS_EXPIRED_AND_LOCKED_TIMED`	A constant which can be used with the status property of a User.
`STATUS_EXPIRED_AND_LOCKED_TIMED_AND_IN_ROL`	A constant which can be used with the status property of a User.
`STATUS_EXPIRED_GRACE`	A constant which can be used with the status property of a User.
`STATUS_EXPIRED_GRACE_AND_LOCKED`	A constant which can be used with the status property of a User.
`STATUS_EXPIRED_GRACE_AND_LOCKED_TIMED`	A constant which can be used with the status property of a User.
`STATUS_LOCKED`	A constant which can be used with the status property of a User.
`STATUS_LOCKED_AND_IN_ROLLOVER`	A constant which can be used with the status property of a User.
`STATUS_LOCKED_TIMED`	A constant which can be used with the status property of a User.
`STATUS_LOCKED_TIMED_AND_IN_ROLLOVER`	A constant which can be used with the status property of a User.
`STATUS_OPEN`	A constant which can be used with the status property of a User.
`STATUS_OPEN_AND_IN_ROLLOVER`	A constant which can be used with the status property of a User.
`all_shared`	Gets the all_shared of this User.
`authentication`	Gets the authentication of this User.
`common`	Gets the common of this User.
`consumer_group`	Gets the consumer_group of this User.
`default_collation`	Gets the default_collation of this User.
`default_tablespace`	[Required] Gets the default_tablespace of this User.
`editions_enabled`	Gets the editions_enabled of this User.
`external_name`	Gets the external_name of this User.
`external_shared`	Gets the external_shared of this User.
`implicit`	Gets the implicit of this User.
`inherited`	Gets the inherited of this User.
`local_temp_tablespace`	Gets the local_temp_tablespace of this User.
`name`	[Required] Gets the name of this User.
`oracle_maintained`	Gets the oracle_maintained of this User.
`password_versions`	Gets the password_versions of this User.
`profile`	[Required] Gets the profile of this User.
`proxy_connect`	Gets the proxy_connect of this User.
`status`	[Required] Gets the status of this User.
`temp_tablespace`	[Required] Gets the temp_tablespace of this User.
`time_created`	[Required] Gets the time_created of this User.
`time_expiring`	Gets the time_expiring of this User.
`time_last_login`	Gets the time_last_login of this User.
`time_locked`	Gets the time_locked of this User.
`time_password_changed`	Gets the time_password_changed of this User.

Methods

__init__(**kwargs) Initializes a new User object with values from keyword arguments.

ALL_SHARED_NO = 'NO'¶: A constant which can be used with the all_shared property of a User. This constant has a value of “NO”

ALL_SHARED_YES = 'YES'¶: A constant which can be used with the all_shared property of a User. This constant has a value of “YES”

AUTHENTICATION_EXTERNAL = 'EXTERNAL'¶: A constant which can be used with the authentication property of a User. This constant has a value of “EXTERNAL”

AUTHENTICATION_GLOBAL = 'GLOBAL'¶: A constant which can be used with the authentication property of a User. This constant has a value of “GLOBAL”

AUTHENTICATION_NONE = 'NONE'¶: A constant which can be used with the authentication property of a User. This constant has a value of “NONE”

AUTHENTICATION_PASSWORD = 'PASSWORD'¶: A constant which can be used with the authentication property of a User. This constant has a value of “PASSWORD”

COMMON_NO = 'NO'¶: A constant which can be used with the common property of a User. This constant has a value of “NO”

COMMON_YES = 'YES'¶: A constant which can be used with the common property of a User. This constant has a value of “YES”

EDITIONS_ENABLED_NO = 'NO'¶: A constant which can be used with the editions_enabled property of a User. This constant has a value of “NO”

EDITIONS_ENABLED_YES = 'YES'¶: A constant which can be used with the editions_enabled property of a User. This constant has a value of “YES”

EXTERNAL_SHARED_NO = 'NO'¶: A constant which can be used with the external_shared property of a User. This constant has a value of “NO”

EXTERNAL_SHARED_YES = 'YES'¶: A constant which can be used with the external_shared property of a User. This constant has a value of “YES”

IMPLICIT_NO = 'NO'¶: A constant which can be used with the implicit property of a User. This constant has a value of “NO”

IMPLICIT_YES = 'YES'¶: A constant which can be used with the implicit property of a User. This constant has a value of “YES”

INHERITED_NO = 'NO'¶: A constant which can be used with the inherited property of a User. This constant has a value of “NO”

INHERITED_YES = 'YES'¶: A constant which can be used with the inherited property of a User. This constant has a value of “YES”

ORACLE_MAINTAINED_NO = 'NO'¶: A constant which can be used with the oracle_maintained property of a User. This constant has a value of “NO”

ORACLE_MAINTAINED_YES = 'YES'¶: A constant which can be used with the oracle_maintained property of a User. This constant has a value of “YES”

PROXY_CONNECT_NO = 'NO'¶: A constant which can be used with the proxy_connect property of a User. This constant has a value of “NO”

PROXY_CONNECT_YES = 'YES'¶: A constant which can be used with the proxy_connect property of a User. This constant has a value of “YES”

STATUS_EXPIRED = 'EXPIRED'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED”

STATUS_EXPIRED_AND_IN_ROLLOVER = 'EXPIRED_AND_IN_ROLLOVER'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED_AND_IN_ROLLOVER”

STATUS_EXPIRED_AND_LOCKED = 'EXPIRED_AND_LOCKED'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED_AND_LOCKED”

STATUS_EXPIRED_AND_LOCKED_AND_IN_ROLLOVER = 'EXPIRED_AND_LOCKED_AND_IN_ROLLOVER'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED_AND_LOCKED_AND_IN_ROLLOVER”

STATUS_EXPIRED_AND_LOCKED_TIMED = 'EXPIRED_AND_LOCKED_TIMED'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED_AND_LOCKED_TIMED”

STATUS_EXPIRED_AND_LOCKED_TIMED_AND_IN_ROL = 'EXPIRED_AND_LOCKED_TIMED_AND_IN_ROL'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED_AND_LOCKED_TIMED_AND_IN_ROL”

STATUS_EXPIRED_GRACE = 'EXPIRED_GRACE'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED_GRACE”

STATUS_EXPIRED_GRACE_AND_LOCKED = 'EXPIRED_GRACE_AND_LOCKED'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED_GRACE_AND_LOCKED”

STATUS_EXPIRED_GRACE_AND_LOCKED_TIMED = 'EXPIRED_GRACE_AND_LOCKED_TIMED'¶: A constant which can be used with the status property of a User. This constant has a value of “EXPIRED_GRACE_AND_LOCKED_TIMED”

STATUS_LOCKED = 'LOCKED'¶: A constant which can be used with the status property of a User. This constant has a value of “LOCKED”

STATUS_LOCKED_AND_IN_ROLLOVER = 'LOCKED_AND_IN_ROLLOVER'¶: A constant which can be used with the status property of a User. This constant has a value of “LOCKED_AND_IN_ROLLOVER”

STATUS_LOCKED_TIMED = 'LOCKED_TIMED'¶: A constant which can be used with the status property of a User. This constant has a value of “LOCKED_TIMED”

STATUS_LOCKED_TIMED_AND_IN_ROLLOVER = 'LOCKED_TIMED_AND_IN_ROLLOVER'¶: A constant which can be used with the status property of a User. This constant has a value of “LOCKED_TIMED_AND_IN_ROLLOVER”

STATUS_OPEN = 'OPEN'¶: A constant which can be used with the status property of a User. This constant has a value of “OPEN”

STATUS_OPEN_AND_IN_ROLLOVER = 'OPEN_AND_IN_ROLLOVER'¶: A constant which can be used with the status property of a User. This constant has a value of “OPEN_AND_IN_ROLLOVER”

__init__(**kwargs)¶

Initializes a new User object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

name (str) – The value to assign to the name property of this User.
status (str) – The value to assign to the status property of this User. Allowed values for this property are: “OPEN”, “EXPIRED”, “EXPIRED_GRACE”, “LOCKED”, “LOCKED_TIMED”, “EXPIRED_AND_LOCKED”, “EXPIRED_GRACE_AND_LOCKED”, “EXPIRED_AND_LOCKED_TIMED”, “EXPIRED_GRACE_AND_LOCKED_TIMED”, “OPEN_AND_IN_ROLLOVER”, “EXPIRED_AND_IN_ROLLOVER”, “LOCKED_AND_IN_ROLLOVER”, “EXPIRED_AND_LOCKED_AND_IN_ROLLOVER”, “LOCKED_TIMED_AND_IN_ROLLOVER”, “EXPIRED_AND_LOCKED_TIMED_AND_IN_ROL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
time_locked (datetime) – The value to assign to the time_locked property of this User.
time_expiring (datetime) – The value to assign to the time_expiring property of this User.
default_tablespace (str) – The value to assign to the default_tablespace property of this User.
temp_tablespace (str) – The value to assign to the temp_tablespace property of this User.
local_temp_tablespace (str) – The value to assign to the local_temp_tablespace property of this User.
time_created (datetime) – The value to assign to the time_created property of this User.
profile (str) – The value to assign to the profile property of this User.
consumer_group (str) – The value to assign to the consumer_group property of this User.
external_name (str) – The value to assign to the external_name property of this User.
password_versions (str) – The value to assign to the password_versions property of this User.
editions_enabled (str) – The value to assign to the editions_enabled property of this User. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
authentication (str) – The value to assign to the authentication property of this User. Allowed values for this property are: “NONE”, “EXTERNAL”, “GLOBAL”, “PASSWORD”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
proxy_connect (str) – The value to assign to the proxy_connect property of this User. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
common (str) – The value to assign to the common property of this User. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
time_last_login (datetime) – The value to assign to the time_last_login property of this User.
oracle_maintained (str) – The value to assign to the oracle_maintained property of this User. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
inherited (str) – The value to assign to the inherited property of this User. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_collation (str) – The value to assign to the default_collation property of this User.
implicit (str) – The value to assign to the implicit property of this User. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
all_shared (str) – The value to assign to the all_shared property of this User. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
external_shared (str) – The value to assign to the external_shared property of this User. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
time_password_changed (datetime) – The value to assign to the time_password_changed property of this User.

all_shared¶

Gets the all_shared of this User. In a sharded database, indicates whether the user is created with shard DDL enabled (YES) or not (NO).

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The all_shared of this User.
Return type:	str

authentication¶

Gets the authentication of this User. The authentication mechanism for the user.

Allowed values for this property are: “NONE”, “EXTERNAL”, “GLOBAL”, “PASSWORD”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The authentication of this User.
Return type:	str

common¶

Gets the common of this User. Indicates whether a given user is common(Y) or local(N).

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The common of this User.
Return type:	str

consumer_group¶

Gets the consumer_group of this User. The initial resource consumer group for the User.

Returns:	The consumer_group of this User.
Return type:	str

default_collation¶

Gets the default_collation of this User. The default collation for the user schema.

Returns:	The default_collation of this User.
Return type:	str

default_tablespace¶

[Required] Gets the default_tablespace of this User. The default tablespace for data.

Returns:	The default_tablespace of this User.
Return type:	str

editions_enabled¶

Gets the editions_enabled of this User. Indicates whether editions have been enabled for the corresponding user (Y) or not (N).

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The editions_enabled of this User.
Return type:	str

external_name¶

Gets the external_name of this User. The external name of the user.

Returns:	The external_name of this User.
Return type:	str

external_shared¶

Gets the external_shared of this User. In a federated sharded database, indicates whether the user is an external shard user (YES) or not (NO).

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The external_shared of this User.
Return type:	str

implicit¶

Gets the implicit of this User. Indicates whether the user is a common user created by an implicit application (YES) or not (NO).

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The implicit of this User.
Return type:	str

inherited¶

Gets the inherited of this User. Indicates whether the user definition is inherited from another container (YES) or not (NO).

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The inherited of this User.
Return type:	str

local_temp_tablespace¶

Gets the local_temp_tablespace of this User. The default local temporary tablespace for the user.

Returns:	The local_temp_tablespace of this User.
Return type:	str

name¶

[Required] Gets the name of this User. The name of the User.

Returns:	The name of this User.
Return type:	str

oracle_maintained¶

Gets the oracle_maintained of this User. Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The oracle_maintained of this User.
Return type:	str

password_versions¶

Gets the password_versions of this User. The list of existing versions of the password hashes (also known as “verifiers”) for the account.

Returns:	The password_versions of this User.
Return type:	str

profile¶

[Required] Gets the profile of this User. The profile name of the user.

Returns:	The profile of this User.
Return type:	str

proxy_connect¶

Gets the proxy_connect of this User. Indicates whether a user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account (that is, by users who have been granted the “connect through” privilege for this account).

Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The proxy_connect of this User.
Return type:	str

status¶

[Required] Gets the status of this User. The status of the user account.

Allowed values for this property are: “OPEN”, “EXPIRED”, “EXPIRED_GRACE”, “LOCKED”, “LOCKED_TIMED”, “EXPIRED_AND_LOCKED”, “EXPIRED_GRACE_AND_LOCKED”, “EXPIRED_AND_LOCKED_TIMED”, “EXPIRED_GRACE_AND_LOCKED_TIMED”, “OPEN_AND_IN_ROLLOVER”, “EXPIRED_AND_IN_ROLLOVER”, “LOCKED_AND_IN_ROLLOVER”, “EXPIRED_AND_LOCKED_AND_IN_ROLLOVER”, “LOCKED_TIMED_AND_IN_ROLLOVER”, “EXPIRED_AND_LOCKED_TIMED_AND_IN_ROL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The status of this User.
Return type:	str

temp_tablespace¶

[Required] Gets the temp_tablespace of this User. The name of the default tablespace for temporary tables or the name of a tablespace group.

Returns:	The temp_tablespace of this User.
Return type:	str

time_created¶

[Required] Gets the time_created of this User. The date and time the user was created.

Returns:	The time_created of this User.
Return type:	datetime

time_expiring¶

Gets the time_expiring of this User. The date and time of the expiration of the user account.

Returns:	The time_expiring of this User.
Return type:	datetime

time_last_login¶

Gets the time_last_login of this User. The date and time of the last user login. This column is not populated when a user connects to the database with administrative privileges, that is, AS { SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSRAC | SYSKM }.

Returns:	The time_last_login of this User.
Return type:	datetime

time_locked¶

Gets the time_locked of this User. The date the account was locked, if the status of the account is LOCKED.

Returns:	The time_locked of this User.
Return type:	datetime

time_password_changed¶

Gets the time_password_changed of this User. The date and time when the user password was last set. This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, this column is null.

Returns:	The time_password_changed of this User.
Return type:	datetime