Use the REVOKE statement (SQL form) to remove security constraint administration privileges from a user or role. For example:
REVOKE [CONSTRAINT DEFINITION|CONSTRAINT ASSIGNMENT] FROM [admin_user_name|admin_role_name]
Syntax elements and descriptions are similar to those for granting constraint privileges.