Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Dec 2005 @ 15:28:22 GMT


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


Subj:   Revoking ALLNESS option on a database privilege
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, December 21, 2005 10:13 -->

We have issued the following grant:

     Grant Select on DATABASEA to all DBC;

Because of the ALL clause, this Select on DATABASEA is cascaded to every new user created in the system.

I want DBC to keep its Select privileges, but not the ALLNESS option. Can I revoke the ALLNESS option from DBC, so that this Select no longer cascades to new users created under DBC, but allowing DBC to keep its Select privileges and also allowing all users who currently have the cascaded Select to keep it?



     
  <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