Granting Users Authorization to the Data Quality Stored Procedures

The dq_grant.sh shell script is provided to enable the Teradata system administrator to grant users authorization to the data quality stored procedures. The dq_grant.sh script is located in the /opt/SAS/SASTKInDatabaseServer/9.4/TeradataonLinux/install/pgm directory of the Teradata database server. Before running the dq_grant.sh script, the Teradata administrator must edit it to specify the site-specific Teradata server name and DBC user logon credentials for the DBC_SRVR=, DBC_USER=, and DBC_PASS= variables. The user name specified in DBC_USER= and DBC_PASS= must have grant authority in the database.

Here is the syntax for executing dq_grant.sh:

./dq_grant.sh <-l log-path> user-name

log-path

specifies an alternative name and location for the dq_grant.sh log. When this parameter is omitted, the script creates a file named dq_grant.log in the current directory.

user-name

is the user name to which permission is being granted. The target user account must already exist in the Teradata database.

The authorizations granted by dq_grant.sh augment existing authorizations that the target user account already has in the Teradata database.

After you have installed the sepcoretera, sepdqacctera, and sasqkb package files and run the dq_install.sh and dq_grant.sh scripts, the installation of the SAS Data Quality Accelerator for Teradata is complete.