User

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

Bases: object

The summary of a specific User.

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 User resource profile name.

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 account status was 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