Gagan gagandeep-dba

## worksheet.sql
# CREATE A READ ONLY GROUP
create role read_only_svc_rl comment = 'This role is limited to querying tables';
grant role read_only_svc_rl to role sysadmin;

# GRANT USAGE ON DATABASE
grant usage on database databots_prod to role read_only_svc_rl;

# GRANT USAGE ON CURRENT SCHEMAS AND FUTURE SCHEMAS
grant usage on all schemas in database databots_prod to role read_only_svc_rl;
grant usage on future schemas in database databots_prod to role read_only_svc_rl;

## keybase.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                gagandeep-dba
                / keybase.md
            
            
              Created
              January 21, 2020 21:49
            
          
        
      
        
  
      
    Keybase proof

I hereby claim:

I am gagandeep-dba on github.
I am gdbdba (https://keybase.io/gdbdba) on keybase.
I have a public key ASDrofz2P5faUZ-brUXpapieVuT-E_MzpNnnpK1tUa0t7go

To claim this, I am signing this object:
	# CREATE A READ ONLY GROUP
	create role read_only_svc_rl comment = 'This role is limited to querying tables';
	grant role read_only_svc_rl to role sysadmin;

	# GRANT USAGE ON DATABASE
	grant usage on database databots_prod to role read_only_svc_rl;

	# GRANT USAGE ON CURRENT SCHEMAS AND FUTURE SCHEMAS
	grant usage on all schemas in database databots_prod to role read_only_svc_rl;
	grant usage on future schemas in database databots_prod to role read_only_svc_rl;