Drops existing authorization for a user.

Syntax


DROP AUTHORIZATION TO remoteSystemName [ FOR userWithAuthorization ];

Arguments

  • remoteSystemName: The remote system where userWithAuthorization has authorization.

  • userWithAuthorization: An optional username for an existing Cirro user with authorization. If userWithAuthorization is not provided, the current session user is default.

Additional Information

Examples


DROP AUTHORIZATION TO ORACLE2 FOR johnsmith;
DROP AUTHORIZATION TO ORACLE2;