CREATE PROFILE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The CREATE PROFILE statement creates a new user profile.
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, which can be changed by the system administrator, is created during installation. It determines the default user attributes when no profile is specified. The initial default profile is:
• NOPRIVILEGES
• NODEFAULT_PRIVILEGES
• NOEXPIRE_DATE
• NOGROUP
• NOSECURITY_AUDIT