Oracle9i DBA -- Database: Fundamentals I (15)

Managing Password Security and Resources
##CONTINUE##

• Resource Limits can be set at session level and call level
• Profiles are assigned to users by the CREATE USER or ALTER USER command
• Enforce the resource limits

  1. by enabling the parameter with the ALTER SYSTEM command

  ALTER SYSTEM SET RESOURCE_LIMIT=TRUE

  2. Set the RESOURCE_LIMIT parameter to TRUE

• Profiles cannot be created by the CREATE user command.
•