Class User

The summary of a specific user resource.

Inheritance
object
User
Inherited Members
Namespace: Oci.DatabasemanagementService.Models
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class User

Properties

AllShared

Declaration
[JsonProperty(PropertyName = "allShared")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.AllSharedEnum? AllShared { get; set; }
Property Value
Type Description
User.AllSharedEnum?

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

Authentication

Declaration
[JsonProperty(PropertyName = "authentication")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.AuthenticationEnum? Authentication { get; set; }
Property Value
Type Description
User.AuthenticationEnum?

The authentication mechanism for the user.

Common

Declaration
[JsonProperty(PropertyName = "common")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.CommonEnum? Common { get; set; }
Property Value
Type Description
User.CommonEnum?

Indicates whether a given user is common(Y) or local(N).

ConsumerGroup

Declaration
[JsonProperty(PropertyName = "consumerGroup")]
public string ConsumerGroup { get; set; }
Property Value
Type Description
string

The initial resource consumer group for the User.

DefaultCollation

Declaration
[JsonProperty(PropertyName = "defaultCollation")]
public string DefaultCollation { get; set; }
Property Value
Type Description
string

The default collation for the user schema.

DefaultTablespace

Declaration
[Required(ErrorMessage = "DefaultTablespace is required.")]
[JsonProperty(PropertyName = "defaultTablespace")]
public string DefaultTablespace { get; set; }
Property Value
Type Description
string

The default tablespace for data.
Remarks

Required

EditionsEnabled

Declaration
[JsonProperty(PropertyName = "editionsEnabled")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.EditionsEnabledEnum? EditionsEnabled { get; set; }
Property Value
Type Description
User.EditionsEnabledEnum?

Indicates whether editions have been enabled for the corresponding user (Y) or not (N).

ExternalName

Declaration
[JsonProperty(PropertyName = "externalName")]
public string ExternalName { get; set; }
Property Value
Type Description
string

The external name of the user.

ExternalShared

Declaration
[JsonProperty(PropertyName = "externalShared")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.ExternalSharedEnum? ExternalShared { get; set; }
Property Value
Type Description
User.ExternalSharedEnum?

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

Implicit

Declaration
[JsonProperty(PropertyName = "implicit")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.ImplicitEnum? Implicit { get; set; }
Property Value
Type Description
User.ImplicitEnum?

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

Inherited

Declaration
[JsonProperty(PropertyName = "inherited")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.InheritedEnum? Inherited { get; set; }
Property Value
Type Description
User.InheritedEnum?

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

LocalTempTablespace

Declaration
[JsonProperty(PropertyName = "localTempTablespace")]
public string LocalTempTablespace { get; set; }
Property Value
Type Description
string

The default local temporary tablespace for the user.

Name

Declaration
[Required(ErrorMessage = "Name is required.")]
[JsonProperty(PropertyName = "name")]
public string Name { get; set; }
Property Value
Type Description
string

The name of the User.
Remarks

Required

OracleMaintained

Declaration
[JsonProperty(PropertyName = "oracleMaintained")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.OracleMaintainedEnum? OracleMaintained { get; set; }
Property Value
Type Description
User.OracleMaintainedEnum?

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

PasswordVersions

Declaration
[JsonProperty(PropertyName = "passwordVersions")]
public string PasswordVersions { get; set; }
Property Value
Type Description
string

The list of existing versions of the password hashes (also known as "verifiers") for the account.

Profile

Declaration
[Required(ErrorMessage = "Profile is required.")]
[JsonProperty(PropertyName = "profile")]
public string Profile { get; set; }
Property Value
Type Description
string

The profile name of the user.
Remarks

Required

ProxyConnect

Declaration
[JsonProperty(PropertyName = "proxyConnect")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.ProxyConnectEnum? ProxyConnect { get; set; }
Property Value
Type Description
User.ProxyConnectEnum?

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).

Status

Declaration
[Required(ErrorMessage = "Status is required.")]
[JsonProperty(PropertyName = "status")]
[JsonConverter(typeof(ResponseEnumConverter))]
public User.StatusEnum? Status { get; set; }
Property Value
Type Description
User.StatusEnum?

The status of the user account.
Remarks

Required

TempTablespace

Declaration
[Required(ErrorMessage = "TempTablespace is required.")]
[JsonProperty(PropertyName = "tempTablespace")]
public string TempTablespace { get; set; }
Property Value
Type Description
string

The name of the default tablespace for temporary tables or the name of a tablespace group.
Remarks

Required

TimeCreated

Declaration
[Required(ErrorMessage = "TimeCreated is required.")]
[JsonProperty(PropertyName = "timeCreated")]
public DateTime? TimeCreated { get; set; }
Property Value
Type Description
DateTime?

The date and time the user was created.
Remarks

Required

TimeExpiring

Declaration
[JsonProperty(PropertyName = "timeExpiring")]
public DateTime? TimeExpiring { get; set; }
Property Value
Type Description
DateTime?

The date and time of the expiration of the user account.

TimeLastLogin

Declaration
[JsonProperty(PropertyName = "timeLastLogin")]
public DateTime? TimeLastLogin { get; set; }
Property Value
Type Description
DateTime?

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 }.

TimeLocked

Declaration
[JsonProperty(PropertyName = "timeLocked")]
public DateTime? TimeLocked { get; set; }
Property Value
Type Description
DateTime?

The date the account was locked, if the status of the account is LOCKED.

TimePasswordChanged

Declaration
[JsonProperty(PropertyName = "timePasswordChanged")]
public DateTime? TimePasswordChanged { get; set; }
Property Value
Type Description
DateTime?

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.