8. SQL Statements : CREATE PROFILE : Description
 
Share this page                  
Description
A user profile is a set of subject privileges and other attributes that can be applied to a user or set of users. Each user can be given a profile, which provides the default attributes for that user.
A profile includes:
Subject privileges
Default subject privileges
Default user groups
Security auditing attributes
Expire date
A default profile, changeable by the system administrator, is created during installation that determines the default user attributes when no profile is explicitly specified. The initial default profile is:
NOPRIVILEGES
NODEFAULT_PRIVILEGES
NOEXPIRE_DATE
NOGROUP
NOSECURITY_AUDIT