User Access details in teradata
SELECT
A.ROLENAME,
A.GRANTEE AS USER_ID,
A.GRANTOR AS ADMIN_ID,
B.DATABASENAME,
B.TABLENAME,
B.GRANTORNAME,
B.ACCESSRIGHT
FROM DBC.ROLEMEMBERS A
JOIN DBC.ALLROLERIGHTS B
ON A.ROLENAME = B.ROLENAME
WHERE GRANTEE= 'UserId'
GROUP BY 1,2,3,4,5,6,7
ORDER BY 2,1,6;
A.ROLENAME,
A.GRANTEE AS USER_ID,
A.GRANTOR AS ADMIN_ID,
B.DATABASENAME,
B.TABLENAME,
B.GRANTORNAME,
B.ACCESSRIGHT
FROM DBC.ROLEMEMBERS A
JOIN DBC.ALLROLERIGHTS B
ON A.ROLENAME = B.ROLENAME
WHERE GRANTEE= 'UserId'
GROUP BY 1,2,3,4,5,6,7
ORDER BY 2,1,6;
Comments
Post a Comment