Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Aug 2002 @ 13:22:30 GMT


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


Subj:   Grant to ALL user
 
From:   Geoffrey Rommel

Suppose you grant access on some database or object to ALL user_name. This means that it is granted to that user/database and also every database owned by that user now and in the future. A row is added to DBC.AccessRights in which the AllnessFlag is 'Y'.

Now suppose you wish to leave the existing rights intact but make sure that that access is not granted in the future to any user under the top-level user_name -- in other words, you wish to leave the row in AccessRights but set AllnessFlag to 'N'. Apparently this is not possible. The manual says, "ALL user_name specifies that the privileges are to be ... revoked from the named database or user, and every database or user owned by that database or user now and in the future."

Shouldn't it be possible to do this?

--wgr



     
  <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: 27 Dec 2016