Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET

The DROP PROFILE statement drops a user profile that is no longer needed.

User profiles are 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 is used to provide the default attributes for that user. A default profile, changeable by the system administrator, is provided to determine the default user attributes when no profile is explicitly specified.

This statement is available in dynamic SQL. It is not available in database procedures. There are no dynamic parameters in embedded SQL.