I have checked the console database to grant execute privilege to viewpoint user and there I dont see any macro for updatespace utility.
But I know, I can access this utility from node through CNStool, but I want to access it through viewpoint remote console.
Please help me to get access on updatespace utility from viewpoint remote console.
If there's no macro, simply create it :-)
replace macro console.updatespace as (;);
And then you can grant EXEC on it.
This is documented in the Viewpoint 14.01 Configuration Guide:
Starting with Viewpoint 14.01, the Remote Console portlet allows access to run the updatespace utility. To enable access to this utility from the portlet, access the Teradata Systems portlet and run the Grant tool, or execute the following SQL against the Teradata Database system:
replace macro console.updatespace as(;); grant exec on console.updatespace to <user>;
Ran into same issue after a restore to a new system from a system that was previously teradata managed. Grants aren't always exported depending on arc config. Just an FYI. This fixes it. Thanks!