Privileges Required for Changing Database Object Modes

To change the mode of a constraint, index, or trigger, you must have the necessary access privileges. You must meet at least one of these requirements:

• You must have the DBA privilege on the database.
• You must be the owner of the table on which the database object is defined and you must also have the Resource privilege on the database.
• You must have the Alter privilege on the table on which the database object is defined and you must also have the Resource privilege on the database.