DROP PROFILE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP PROFILE statement drops a user profile that is no longer needed.
The DROP PROFILE statement has the following format:
[EXEC SQL] DROP PROFILE profile_name [RESTRICT | CASCADE]
RESTRICT
(Default) Specifies that if any users have this profile the statement is rejected.
CASCADE
Specifies that any users with this profile have their profile reset to the default profile.
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.
Permissions
You must have MAINTAIN_USERS privilege and be connected to the iidbdb database.
Locking
The DROP PROFILE statement locks iiprofile.
Related Statements
ALTER PROFILE
CREATE PROFILE
Last modified date: 01/30/2023