Managing Security for Oracle AI Database Users

You can manage the security for Oracle AI Database users in many ways, such as enforcing restrictions on the way that passwords are created.

• About User Security
  You can secure users accounts through strong passwords and by specifying special limits for the users.

• Creating User Accounts
  A user account can have restrictions such as profiles, a default role, and tablespace restrictions.

• Altering User Accounts
  The ALTER USER statement modifies user accounts, such their default tablespace or profile, or changing a user’s password.

• Configuring User Resource Limits
  A resource limit defines the amount of system resources that are available for a user.

• Dropping User Accounts
  You can drop user accounts if the user is not in a session, and if the user has objects in the user’s schema.

• Predefined Schema User Accounts Provided by Oracle Database
  The Oracle Database installation process creates predefined administrative, non-administrative, and sample schema user accounts in the database.

• Database User and Profile Data Dictionary Views
  Oracle Database provides a set of data dictionary views that provide information about the settings that you used to create users and profiles.