Implementing profiles

Enforcing profile limits is a three-step process:

  1. Profiles must be defined with the CREATE PROFILE command.

  2. Profiles must be assigned to users with the CREATE USER or ALTER USER command.

  3. Limit checking must be enabled globally at the database level. This can be done either through the INIT.ORA parameter RESOURCE_LIMITS or through the ALTER SYSTEM commands. See Chapter 12, and Chapter 13, for the complete syntax.

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial