Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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	Next>	Last>>