AccessRight definitions

Tools & Utilities
Enthusiast

AccessRight definitions

Anyone know the AccessRight definitions for IX and RF
Writing a program that will list the complete list of access rights for a Teradata id

SEL 'GRANT '||
CASE
WHEN ACCESSRIGHT = 'CD' THEN 'CREATE DATABASE'
WHEN ACCESSRIGHT = 'CG' THEN 'CREATE TRIGGER'
WHEN ACCESSRIGHT = 'CM' THEN 'CREATE MACRO'
WHEN ACCESSRIGHT = 'CP' THEN 'CHECKPOINT'
WHEN ACCESSRIGHT = 'CT' THEN 'CREATE TABLE'
WHEN ACCESSRIGHT = 'CU' THEN 'CREATE USER'
WHEN ACCESSRIGHT = 'CV' THEN 'CREATE VIEW'
WHEN ACCESSRIGHT = 'D' THEN 'DELETE'
WHEN ACCESSRIGHT = 'DD' THEN 'DROP DATABASE'
WHEN ACCESSRIGHT = 'DG' THEN 'DROP TRIGGER'
WHEN ACCESSRIGHT = 'DM' THEN 'DROP MACRO'
WHEN ACCESSRIGHT = 'DP' THEN 'DUMP'
WHEN ACCESSRIGHT = 'DT' THEN 'DROP TABLE'
WHEN ACCESSRIGHT = 'DU' THEN 'DROP USER'
WHEN ACCESSRIGHT = 'DV' THEN 'DROP VIEW'
WHEN ACCESSRIGHT = 'E' THEN 'EXECUTE'
WHEN ACCESSRIGHT = 'I' THEN 'INSERT'
WHEN ACCESSRIGHT = 'IX' THEN '? IX'
WHEN ACCESSRIGHT = 'PC' THEN 'CREATE PROCEDURE'
WHEN ACCESSRIGHT = 'PD' THEN 'DROP PROCEDURE'
WHEN ACCESSRIGHT = 'PE' THEN 'EXECUTE PROCEDURE'
WHEN ACCESSRIGHT = 'R'THEN 'SELECT'
WHEN ACCESSRIGHT = 'RF' THEN '? RF'
WHEN ACCESSRIGHT = 'RS' THEN 'RESTORE'
WHEN ACCESSRIGHT = 'U' THEN 'UPDATE'
END
||' ON '||TRIM(TRAILING FROM DATABASENAME)||' TO '|| 'TAPESTRY_PROD' /* user being Granted the access The recipiant Copy TO: --->*/
||
CASE
WHEN GRANTAUTHORITY = 'N' THEN ';'
ELSE ' WITH GRANT OPTION;'
END
FROM DBC.ALLRIGHTS WHERE
ACCESSRIGHT IN
('CD','CG','CM','CP','CT','CU','CV','D','DD','DG','DM','DP','DT','DU','DV','E','I',’IX’,'PC','PD','PE','R',’RF’,'RS','U')

/* Copy the access from this user Copy from---> */
and USERNAME = 'IMS_PROD'
and DATABASENAME <> 'IMS_PROD '
group by 1;
1 REPLY
Enthusiast

Re: AccessRight definitions

From DD manual.

IX INDEX
RF REFERENCE