User¶
- class oci.database_management.models.User(**kwargs)¶
Bases:
objectThe summary of a specific user resource.
Attributes:
A constant which can be used with the all_shared property of a User.
A constant which can be used with the all_shared property of a User.
A constant which can be used with the authentication property of a User.
A constant which can be used with the authentication property of a User.
A constant which can be used with the authentication property of a User.
A constant which can be used with the authentication property of a User.
A constant which can be used with the common property of a User.
A constant which can be used with the common property of a User.
A constant which can be used with the editions_enabled property of a User.
A constant which can be used with the editions_enabled property of a User.
A constant which can be used with the external_shared property of a User.
A constant which can be used with the external_shared property of a User.
A constant which can be used with the implicit property of a User.
A constant which can be used with the implicit property of a User.
A constant which can be used with the inherited property of a User.
A constant which can be used with the inherited property of a User.
A constant which can be used with the oracle_maintained property of a User.
A constant which can be used with the oracle_maintained property of a User.
A constant which can be used with the proxy_connect property of a User.
A constant which can be used with the proxy_connect property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
A constant which can be used with the status property of a User.
Gets the all_shared of this User.
Gets the authentication of this User.
Gets the common of this User.
Gets the consumer_group of this User.
Gets the default_collation of this User.
[Required] Gets the default_tablespace of this User.
Gets the editions_enabled of this User.
Gets the external_name of this User.
Gets the external_shared of this User.
Gets the implicit of this User.
Gets the inherited of this User.
Gets the local_temp_tablespace of this User.
[Required] Gets the name of this User.
Gets the oracle_maintained of this User.
Gets the password_versions of this User.
[Required] Gets the profile of this User.
Gets the proxy_connect of this User.
[Required] Gets the status of this User.
[Required] Gets the temp_tablespace of this User.
[Required] Gets the time_created of this User.
Gets the time_expiring of this User.
Gets the time_last_login of this User.
Gets the time_locked of this User.
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.
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
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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
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
- property 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
- property 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
- property 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
- property name¶
[Required] Gets the name of this User. The name of the User.
- Returns
The name of this User.
- Return type
str
- property 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
- property 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
- property profile¶
[Required] Gets the profile of this User. The profile name of the user.
- Returns
The profile of this User.
- Return type
str
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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