Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2010 @ 08:58:08 GMT


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


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



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