crashwave icon

Script Grant Select for all Views

crashwave | PRO | 01/27/21 06:59:45 PM UTC (Edited) | 0 ⭐ | 11195 👁️ | Never ⏰ | []
SQL |

160 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
/*This generates scripts to Grant Select on all views to a user %USER% */
SELECT 'GRANT SELECT ON ' + TABLE_NAME + ' TO %USER%'
FROM INFORMATION_SCHEMA.Views
 

Comments

  • icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
    
    

    

            
    • 
            
            
  • 
                
    
                    
    
                         icon
                    
    
                    
    
                        
                        
                        
                    
    
                    
    
                        
                        01/01/70 12:00:00 AM UTC
                        
                    
    
                
    
                

    
    
    
        
    
            Plain Text
            |
            
    0 B
    
            
            |
            
     👍
    
            /
            
     👎
    
        
    
        
    
    
    
    
        
    
    
    

    

            
    •