Authorization
To drop a table, view, index, alias, or package, the privileges held by
the authorization ID of the statement must include at least one of the following:
- The following system authorities:
- The system authorities of *OBJOPR and *OBJEXIST on the object to be dropped
- If the object is a table or view, the system authorities of *OBJOPR and
*OBJEXIST on any views, indexes, and logical files that are dependent on that
table or view
- The system authority *EXECUTE on the library that contains the object
to be dropped
- Administrative authority
To drop a schema, the privileges held by the authorization ID of the statement
must include at least one of the following:
- The following system authorities:
- The system authorities of *OBJEXIST, *OBJOPR, *EXECUTE, and *READ on the
library to be dropped.
- The system authorities of *OBJOPR and *OBJEXIST on all objects in the
schema and *OBJOPR and *OBJEXIST on any views, indexes and logical files that
are dependent on tables and views in the schema.
- Any additional authorities required to delete other object types that
exist in the schema. For example, *OBJMGT to the data dictionary if the schema
contains a data dictionary, and some system data authority to the journal
receiver. For more information, see the iSeries Security
Reference
book.
- Administrative authority
To drop a distinct type, the privileges held by the authorization ID of the statement
must include at least one of the following:
- The following system authorities:
- The system authorities of *OBJOPR and *OBJEXIST on the distinct type to be dropped
- The system authority *EXECUTE on the library that contains the distinct type to
be dropped
- The DELETE privilege on the SYSTYPES, SYSPARMS, and SYSROUTINES catalog
tables, and
- The system authority *EXECUTE on library QSYS2
- Administrative authority
To drop a function, the privileges held by the authorization ID of the
statement must include at least one of the following:
- The following system authorities:
- For SQL functions, the system authority *OBJEXIST on the service program
object associated with the function, and
- The DELETE privilege on the SYSFUNCS, SYSPARMS, and SYSROUTINEDEP
catalog tables, and
- The system authority *EXECUTE on library QSYS2
- Administrative authority
To drop a procedure, the privileges held by the authorization ID of the
statement must include at least one of the following:
- The following system authorities:
- For SQL procedures, the system authority *OBJEXIST on the program object
associated with the procedure, and
- The DELETE privilege on the SYSPROCS, SYSPARMS, and SYSROUTINEDEP
catalog tables, and
- The system authority *EXECUTE on library QSYS2
- Administrative authority
To drop a sequence, the privileges held by the authorization ID of the
statement must include at least one of the following:
- The following system authorities:
- The system authority *OBJEXIST on the data area associated with the sequence,
and
- The system authority *EXECUTE on the library that contains
the sequence to be dropped
- The DELETE privilege on the SYSSEQOBJECTS catalog table, and
- The system authority *EXECUTE on library QSYS2, and
- *USE to the Delete Data Area (DLTDTAARA) command
- Administrative authority
To drop a trigger, the privileges held by the authorization ID of the statement
must include at least one of the following:
- The following privileges:
- The system authority *USE to the Remove Physical File Trigger (RMVPFTRG)
command, and
- For the subject table or view of the trigger:
- The ALTER privilege to the subject table or view, and
- The system authority *EXECUTE on the library containing the subject table
or view,
- If the trigger being dropped is an SQL trigger:
- The system authority *OBJEXIST on the trigger program object, and
- The system authority *EXECUTE on the library containing the trigger.
- Administrative authority
For information on the system authorities corresponding to SQL privileges,
see Corresponding System Authorities When Checking Privileges to a Table or View.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.