DROP AUTHORIZATION in Teradata
Authorization object will be dropped by the above command.

Syntax: 
DROP AUTHORIZATION .authorizationname


The following example drops the authorization object named emp from the dictionary. 
DROP AUTHORIZATION emp;