FORMAT Options 469 Example gphdfs to pxf External Table Mapping for an HDFS Text File 470 Verifying Access with PXF 470 Removing the gphdfs External Tables 470 Revoking Privileges to the gphdfs Protocol Connections 523 Configuring Database Authorization 524 Access Permissions and Roles 524 Managing Object Privileges 525 About Object Access Privileges 525 About Password Encryption in Greenplum Database Individual Session 527 VMware Greenplum 6 Documentation VMware by Broadcom 25 Example 528 Restricting Access by Time 529 Example 1 – Create a New Role with Time-based Constraints 530 Example 2 – Alter a Role

FORMAT Options 450 Example gphdfs to pxf External Table Mapping for an HDFS Text File 451 Verifying Access with PXF 451 Removing the gphdfs External Tables 451 Revoking Privileges to the gphdfs Protocol Connections 494 Configuring Database Authorization 495 Access Permissions and Roles 495 Managing Object Privileges 495 About Object Access Privileges 496 About Password Encryption in Greenplum Database Setting the SHA-256 Password Hash Algorithm for an Individual Session 498 Example 499 Restricting Access by Time 499 Example 1 – Create a New Role with Time-based Constraints 501 Example 2 – Alter a Role

FORMAT Options 475 Example gphdfs to pxf External Table Mapping for an HDFS Text File 475 Verifying Access with PXF 476 Removing the gphdfs External Tables 476 Revoking Privileges to the gphdfs Protocol Connections 518 Configuring Database Authorization 519 Access Permissions and Roles 519 Managing Object Privileges 519 About Object Access Privileges 520 About Password Encryption in Greenplum Database Setting the SHA-256 Password Hash Algorithm for an Individual Session 522 Example 523 Restricting Access by Time 523 Example 1 – Create a New Role with Time-based Constraints 525 Example 2 – Alter a Role

FORMAT Options 459 Example gphdfs to pxf External Table Mapping for an HDFS Text File 459 Verifying Access with PXF 460 Removing the gphdfs External Tables 460 Revoking Privileges to the gphdfs Protocol Connections 498 Configuring Database Authorization 499 Access Permissions and Roles 499 Managing Object Privileges 499 About Object Access Privileges 500 About Password Encryption in Greenplum Database Setting the SHA-256 Password Hash Algorithm for an Individual Session 502 Example 503 Restricting Access by Time 503 Example 1 – Create a New Role with Time-based Constraints 505 Example 2 – Alter a Role

FORMAT Options 456 Example gphdfs to pxf External Table Mapping for an HDFS Text File 456 Verifying Access with PXF 457 Removing the gphdfs External Tables 457 Revoking Privileges to the gphdfs Protocol Connections 496 Configuring Database Authorization 497 Access Permissions and Roles 497 Managing Object Privileges 497 About Object Access Privileges 498 About Password Encryption in Greenplum Database Individual Session 500 Example 501 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 21 Restricting Access by Time 501 Example 1 – Create a New Role with Time-based Constraints 503 Example 2 – Alter a Role

FORMAT Options 385 Example gphdfs to pxf External Table Mapping for an HDFS Text File 385 Verifying Access with PXF 386 Removing the gphdfs External Tables 386 Revoking Privileges to the gphdfs Protocol Configuring Database Authorization 421 Access Permissions and Roles 421 VMware Tanzu Greenplum 6 Documentation VMware, Inc 19 Managing Object Privileges 422 About Object Access Privileges 423 About Password Setting the SHA-256 Password Hash Algorithm for an Individual Session 425 Example 425 Restricting Access by Time 426 Example 1 – Create a New Role with Time-based Constraints 427 Example 2 – Alter a Role

Client/Server Connections 289 Configuring Database Authorization 290 Access Permissions and Roles 290 Managing Object Privileges 291 Restricting Access by Time 292 Example 1 – Create a New Role with Time-based Distribution 344 Changing the Distribution Policy 344 Redistributing Table Data 344 Altering the Table Access Method 344 Altering the Table Storage Model 345 Inheritance Rules for Altering a Partitioned Table’s Considerations 418 Accessing External Data with External Tables 418 About the External Table Data Access Protocols 418 About External Table Operations 419 About the External Table Types 420 Creating

VMware Greenplum v6.18 Documentation VMware, Inc. 36 Managing Greenplum Database Access 634 Managing Greenplum Database Access 0 Configuring Client Authentication 634 Configuring Client Authentication 671 Altering Role Attributes 659 Role Membership 660 Managing Object Privileges 661 Simulating Row Level Access Control 663 Encrypting Data 663 Protecting Passwords in Greenplum Database 663 Time-based Authentication Client/Server Connections 685 Configuring Database Authorization 685 Configuring Database Authorization 0 Access Permissions and Roles 685 Managing Object Privileges 686 Using SSH-256 Encryption 687 Setting

VMware Greenplum v6.19 Documentation VMware, Inc. 37 Managing Greenplum Database Access 643 Managing Greenplum Database Access 0 Configuring Client Authentication 643 Configuring Client Authentication 680 Altering Role Attributes 668 Role Membership 669 Managing Object Privileges 670 Simulating Row Level Access Control 672 Encrypting Data 672 Protecting Passwords in Greenplum Database 672 Time-based Authentication Client/Server Connections 694 Configuring Database Authorization 694 Configuring Database Authorization 0 Access Permissions and Roles 694 Managing Object Privileges 695 Using SSH-256 Encryption 696 Setting

Patching and Upgrading 565 Managing Greenplum Database Access 566 VMware Greenplum v6.17 Documentation VMware, Inc. 32 Managing Greenplum Database Access 0 Configuring Client Authentication 566 Configuring Altering Role Attributes 591 Role Membership 592 Managing Object Privileges 593 Simulating Row Level Access Control 595 Encrypting Data 595 Protecting Passwords in Greenplum Database 595 Time-based Authentication Client/Server Connections 617 Configuring Database Authorization 617 Configuring Database Authorization 0 Access Permissions and Roles 617 Managing Object Privileges 618 Using SSH-256 Encryption 619 Setting