Restrict a user access to certain time window

Database

Restrict a user access to certain time window

Hello All,

I was given a task to create a user in Tera data system with following restrictions:

1) Not allow user of a particular role to run any queries between 4a.m. - 8a.m. in the morning.
2) Not allow user of a particular role to run long running queries (Maximum 30 minutes)

Can you please advise how I can achieve this business need?

Thanks,
Murali
3 REPLIES

Re: Restrict a user access to certain time window

Check the manuals for Teradata Dynamic Workload Manager. I believe it will allow you to accomplish what you have spelled out.
Teradata Employee

Re: Restrict a user access to certain time window

As mentioned, Teradata Active System Management (TASM) can provide those types of query limitations.

Re: Restrict a user access to certain time window

You can achieve this with the help of Dynamic Workload Manager.
1> Create user & assign a certain workload c lass, say WD_ConsoleM
2> Go to Dynamic Workload Manager and define periods according to your needs
3> In the Dynamic Workload Manager, select the workload class & define the exception criterion & the actions you want to take.