|
|
|
Valid in: SQL, ESQL
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.
|
|
|
The Drop Profile statement has the following format:
[EXEC SQL] DROP PROFILE profile_name [CASCADE | RESTRICT]
Specifies that any users with this profile have their profile reset to the default profile.
(Default) Specifies that if any users have this profile the statement is rejected.
|
|
|
You must have the maintain_user privilege and be connected to the iidbdb database.
|
|
|
The Drop Profile statement locks iiprofile.
|
|
|
|
|
|
The following example drops the myprofile profile:
drop profile myprofile cascade