To check the rights given for a database for creating a table in it in Teradata

You can check all the rights given for all the databases, tables and users by using the following query.

SELECT *
FROM dbc.allrights 
WHERE accessright = 'CT'
AND GrantAuthority = 'Y'
AND DatabaseName = 'database where table will be created'
AND UserName = 'database where macro/view/table was created'