Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Dec 2005 @ 14:02:18 GMT


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


Subj:   Re: SET Role in Fastload
 
From:   Diane Wilson

  How to assign the default role to user. Do we need to use "Grant Role" command for that? You mean in that case we don't need to set the role every time?  



     MODIFY USER theuser AS DEFAULT ROLE = thenewdefaultrole;

However,

You may not want to have the role as the default role, as the default role may also be required.

So if you GRANT rolename To username, then you wont need to set the role every time the user signs on.

The idea behind roles is that you can set up multiple roles and assign multiple roles to a user or group of users


Di



     
  <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: 15 Jun 2023