DROP AUTHORIZATION in Teradata

Authorization object will be dropped by the above command.

Syntax:
DROP AUTHORIZATION <databasename>.authorizationname


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