Access to the Update space utility denied in viewpoint remote console.

Viewpoint

Access to the Update space utility denied in viewpoint remote console.

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.

--Thanks

3 REPLIES
N/A

Re: Access to the Update space utility denied in viewpoint remote console.

If there's no macro, simply create it :-)

replace macro console.updatespace as (;);

And then you can grant EXEC on it.

Dieter

Teradata Employee

Re: Access to the Update space utility denied in viewpoint remote console.

This is documented in the Viewpoint 14.01 Configuration Guide:

Post Installation

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>; 



Teradata Employee

Re: Access to the Update space utility denied in viewpoint remote console.

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!