PURPOSE: The UNSECURE command removes security.
The user must be identified as being authorized with a PERMIT command for the level of security that is to be removed. To remove the DBA level of security, DBA authorization must be set with the PERMIT DBA command.
To remove the DBL level of security, DBA authorization must be set (PERMIT DBA command) or the ALTER security privilege must be set for the DBL.
To remove security for a DBL object, do one of the following:
Set DBA authorization with the PERMIT DBA command.- Enter the DBL password in the PERMIT PASSWORD command if the ALTER security privilege is set for the DBL.
- Enter the object password in the PERMIT PASSWORD command if the ALTER security privilege is set for the object.
SYNTAX
UNSECURE secured_object_type secured_object_name
secured_object_type |
could be one of the following:
|
secured_object_name |
is the name of the object to have its security removed. |
Example
*UNSECURE DS AUTHORS