Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$RO_USER_ACCOUNT

V$RO_USER_ACCOUNT is populated only on Oracle databases that are open in read-only mode. When a database is read-only, security data cannot be stored in normal catalogue tables. Instead, the security data is stored in an in-memory table that is queried through this view.

In an Oracle Data Guard environment, some of the security information for user accounts on the standby is inherited from the primary server. For example, if the account is locked out unlimited on the primary, then it will be locked on the standby database(s). The information stored on the standby is volatile information that user actions on the standby database(s) can affect, such as the number of failed logins, and the time the account was locked on the standby due to failed access attempts. Note that failed login attempts on standbys do not affect the account status on primaries.

Column Datatype Description
USERID NUMBER User ID number
PASSW_EXPIRED NUMBER Indicates whether the password has expired (Y) or not (N)
PASSW_IN_GRACE NUMBER Indicates whether the account is in grace (Y) or not (N)
PASSW_LOCKED NUMBER Indicates whether the account is locked (Y) or not (N)
PASSW_LOCK_UNLIM NUMBER Indicates whether the account is locked for an unlimited time (Y) or not (N)
FAILED_LOGINS NUMBER The number of failed login attempts. The count is not cumulative; it is reset upon successful logon to the account
EXPIRATION_AFTER_GRACE TIMESTAMP(3) The expiration time after grace
PASSW_LOCK_TIME TIMESTAMP(3) The time the account was locked out
CON_ID NUMBER The ID of the container to which the data pertains. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data