names = new ArrayList(); names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); return names.iterator(); } } Returning a SETOF A ALTER ROLE or CREATE ROLE commands to assign a resource group to a role. For example: =# ALTER ROLE bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; You can assign a resource group CREATEEXTTABLE(type='writable', protocol='gpfdist'); Create a role, assigning a resource group: CREATE ROLE bill RESOURCE GROUP rg_light; Compatibility The SQL standard defines the concepts of users and roles

ArrayList names = new ArrayList(); names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); VMware Greenplum 6 Documentation VMware, Inc 964 return for the admin_group to zero (0). VMware Greenplum 6 Documentation VMware, Inc 1186 =# ALTER ROLE bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; You can assign a resource group CREATEEXTTABLE(type='writable', protocol='gpfdist'); Create a role, assigning a resource group: CREATE ROLE bill RESOURCE GROUP rg_light; Compatibility The SQL standard defines the concepts of users and roles

names = new ArrayList(); names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); return names.iterator(); } } Returning a SETOF bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; Note You cannot set or alter CREATEEXTTABLE(type='writable', protocol='gpfdist'); Create a role, assigning a resource group: CREATE ROLE bill RESOURCE GROUP rg_light; Compatibility The SQL standard defines the concepts of users and roles

51 | sd w1 | 6000 | bill | READY | prc10000003300000003 3 | 1a6b29f0f4cad514a8c3936f9239c50d | prc1 | 51 | sd w1 | 6001 | bill | READY | prc10000003300000003 51 | sd w2 | 6000 | bill | READY | prc10000003300000003 5 | f10f180133acff608275d87966f8c7d9 | prc1 | 51 | sd w2 | 6001 | bill | READY | prc10000003300000003 51 | sd w3 | 6000 | bill | READY | prc10000003300000003 7 | 037f8c747a5dc1b75fb10524b676b9e8 | prc1 | 51 | sd w3 | 6001 | bill | READY | prc10000003300000003

ArrayList names = new ArrayList(); names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); VMware Tanzu Greenplum 6 Documentation VMware, Inc 812 return ALTER ROLE or CREATE ROLE commands to assign a resource group to a role. For example: =# ALTER ROLE bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; You can assign a resource group CREATEEXTTABLE(type='writable', protocol='gpfdist'); Create a role, assigning a resource group: CREATE ROLE bill RESOURCE GROUP rg_light; Compatibility The SQL standard defines the concepts of users and roles

ArrayList names = new ArrayList(); names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); return names.iterator(); } } VMware Tanzu Greenplum 6 ALTER ROLE or CREATE ROLE commands to assign a resource group to a role. For example: =# ALTER ROLE bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; You can assign a resource group assigning a resource group: VMware Tanzu Greenplum 6 Documentation VMware, Inc 1481 CREATE ROLE bill RESOURCE GROUP rg_light; Compatibility The SQL standard defines the concepts of users and roles

Documentation VMware, Inc. 929 names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); return names.iterator(); } } Returning a SETOF bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; You can assign a resource group CREATEEXTTABLE(type='writable', protocol='gpfdist'); Create a role, assigning a resource group: CREATE ROLE bill RESOURCE GROUP rg_light; Compatibility The SQL standard defines the concepts of users and roles

names = new ArrayList(); names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); return names.iterator(); } } Returning a SETOF bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; You can assign a resource group CREATEEXTTABLE(type='writable', protocol='gpfdist'); Create a role, assigning a resource group: CREATE ROLE bill RESOURCE GROUP rg_light; Compatibility The SQL standard defines the concepts of users and roles

names = new ArrayList(); names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); return names.iterator(); } } Returning a SETOF bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; You can assign a resource group CREATEEXTTABLE(type='writable', protocol='gpfdist'); Create a role, assigning a resource group: CREATE ROLE bill RESOURCE GROUP rg_light; VMware Greenplum v6.18 Documentation VMware, Inc. 1284 Compatibility

names = new ArrayList(); names.add("Lisa"); names.add("Bob"); names.add("Bill"); names.add("Sally"); return names.iterator(); } } Returning a SETOF bill RESOURCE GROUP rg_light; =# CREATE ROLE mary RESOURCE GROUP exec; You can assign a resource group CREATEEXTTABLE(type='writable', protocol='gpfdist'); Create a role, assigning a resource group: CREATE ROLE bill RESOURCE GROUP rg_light; VMware Greenplum v6.19 Documentation VMware, Inc. 1293 Compatibility