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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset