Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 19 Dec 2001 @ 17:48:59 GMT


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


Subj:   Re: SYSDBA PRIORITY
 
From:   David Wellman

Jacques,

If you want to change a user's priority then you need to issue a "modify user" command. In order to do this you need the "drop user" privilege (or AccessRight) on the user concerned.

In a Teradata environment, ANY user can be granted the privilege to issue a particular command.

Assume that the user that you want to change the priority for is called "U1" and you want to use user SYSDBA to issue this command, then your database security administrator needs to issue the following;

GRANT DROP USER ON U1 TO SYSDBA;

Once this is done, SYSDBA can then issue the "modify user" command to change the priority for user "U1".

Dave



     
  <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: 28 Jun 2020