Manage Drop privilege

To grant or revoke Drop privileges on an object:

• GRANT DROP ON object TO entity;
• REVOKE DROP ON object FROM entity;

Always specify a complete signature for the object value. For example, to grant Drop privileges for the sample function CustomerName to the user newuser:

GRANT DROP ON CustomerName(varchar(64000)) TO newuser;

To grant Drop privilege on all aggregates to the user newuser:

GRANT DROP ON AGGREGATE TO newuser;

To revoke Drop privileges on the CustomerName function from the user myuser:

REVOKE DROP ON CustomerName(varchar(64000)) FROM myuser;