4. Authorizing User Access : Users and Profiles : Working with Profile Objects : Default Profile
Share this page                  
Default Profile
A default profile is the profile initially assigned to a user if one is not explicitly assigned.
The default profile specifies the following:
No default group
No subject privileges or default privileges
No expiration date
No security audit options (that is, default events are audited)
Note:  You can alter the default profile but you cannot drop it.
Note:  Altering the default profile will alter privilege attributes of all users that have not been given a specific profile.
You can change the default profile using the ALTER DEFAULT PROFILE statement, Actian Director, or VDBA.