Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 14 Feb 2008 @ 22:11:51 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: How to revoke abort session from pmon for developers
From:   Dempsey, Mike

Joseph's suggestion is on the right lines I think.

The fact that the user is not able to Abort sessions through one tool but able to through another implies that there are 2 different sets of rules governing the situation.

If your user connects directly to the Teradata DBS (Via PMON or Teradata Manager) then the security rights will be checked by the DBS itself, so the standard Grant/Revoke rights will apply.

If your user connects to the Terdata Manager service then the Teradata Manager profile that they are using will control what they are able to do. (The session used by the TMgr servise is not the user's session so it has nothing to do with that user's rights.)

The Teradata Manager Profile allows you to specify many different rights. Those marked by an asterix are 'action' type rights that you should generaly NOT grant to end users.

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020