Use VALIDATE AUTHORIZATION to give authorization to the given datasource using the supplied username and password.

Syntax

VALIDATE AUTHORIZATION TO datasource OPTIONS (USERNAME 'username', PASSWORD 'password');

Arguments

  • datasource - an existing datasource, added to cirro with CREATE SYSTEM.

  • USERNAME and PASSWORD - database user account name and password.

Examples

VALIDATE AUTHORIZATION TO Ora1 OPTIONS (USERNAME 'cirrouser', PASSWORD 'mycirropassword');