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:

To drop a schema, the privileges held by the authorization ID of the statement must include at least one of the following:

To drop a distinct type, the privileges held by the authorization ID of the statement must include at least one of the following:

To drop a function, the privileges held by the authorization ID of the statement must include at least one of the following:

To drop a procedure, the privileges held by the authorization ID of the statement must include at least one of the following:

To drop a sequence, the privileges held by the authorization ID of the statement must include at least one of the following:

To drop a trigger, the privileges held by the authorization ID of the statement must include at least one of the following:

For information on the system authorities corresponding to SQL privileges, see Corresponding System Authorities When Checking Privileges to a Table or View.