Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2012 @ 22:11:34 GMT

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

Subj:   Re: Grant & Role Issue
From:   Bhattiprolu, Phaneendra

Ensure that the ROLE rights are available upon logon. It is simple by setting the default ROLE to ALL ROLES. This makes all rights from various roles granted to the user active during logon. Otherwise, user has to execute the statement, "SET ROLE R_XYZ_RO;".

  <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