 |
 |
Archives of the TeradataForum
Message Posted: Tue, 20 Jul 2010 @ 08:58:08 GMT
| Subj: | | Re: Monitor access |
| |
| From: | | Dieter Noeth |
Martin Barrow wrote:
| | When we are granting monitor access to users to use PMON they are also getting the ability to modify priority using the Modify Acct
button. | |
Modify account should only be possible for the ABORTSESSION right.
| | The script we run is grant monsession to user1; | |
| | Can anyone advise what needs to be done to give the monitor access, but not the ability to modify/abort anything. | |
You should check if there's another access right:
select * from dbc.accessrights
where accessright in
('MR' -- MONRESOURCE
,'MS' -- MONSESSION
,'SS' -- SETRESRATE
,'SR' -- SETSESSRATE
,'AS' -- ABORTSESSION
)
and username = 'user1'
Dieter
| |
