Restricting the number of sessions for specific DB users

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Teradata Employee

Restricting the number of sessions for specific DB users

Hello , this is David. 

I want confirm one thing that

「Want limit the number of sessions that can be created by newly created DB users.」

How can I do the process ?

thanks in advacn

Best regards 

David 


Accepted Solutions
Senior Apprentice

Re: Restricting the number of sessions for specific DB users

Hi David,

 

You can do this for a user (newly created or not) by using workload management. This would be a throttle - probably system throttle - which limits the number of concurrent sessions that a username can logon.

 

Check the VP manual ("Workload Designer" portlet) for details.

 

HTH
Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
1 ACCEPTED SOLUTION
2 REPLIES
Senior Apprentice

Re: Restricting the number of sessions for specific DB users

Hi David,

 

You can do this for a user (newly created or not) by using workload management. This would be a throttle - probably system throttle - which limits the number of concurrent sessions that a username can logon.

 

Check the VP manual ("Workload Designer" portlet) for details.

 

HTH
Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Teradata Employee

Re: Restricting the number of sessions for specific DB users

Hello dearDave
 
 
 
 
 
 
 
really thanks for your help.
 best regards. David.