Archives of the TeradataForum
Message Posted: Thu, 19 Dec 2002 @ 17:36:50 GMT
| Subj: | | Re: New Years Wish List |
| |
| From: | | Dennis Calkins |
Adam DeYoung wrote:
| | 3) I really liked the idea about Teradata knowing that certain users cannot manage to submit optimized SQL and automatically
rejecting their request, so I'll use my third wish to support that effort. | |
This is called TDQM and is available in v2r4.1 and beyond.
Unfortunately the DBA has to know that BOB is the person who needs to be restricted and make a rule saying BOB can't submit SQL.
Actually you can make rules which restrict based upon types of joins, estimated number of rows, estimated spool size so that if BOB
would accidently submit a query from JIM's terminal it would block it as well.
TDQM is differnt than the DBQM enabled ODBC driver from v2r3 (which could only restrict requests coming from The PCs with that ODBC
driver installed via applications using ODBC), in that it is implemented inside the Server and can restrict any query coming from any source
that matches the rules specified.
Would that Satisfy this wish?
| 
