Managing Security for Oracle Database Users

You can manage the security for Oracle 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.