290 Access Permissions and Roles 290 Managing Object Privileges 291 Restricting Access by Time 292 Example 1 – Create a New Role with Time-based Constraints 293 Example 2 – Alter a Role to Add Time-based Time-based Constraints 293 Excample 3 – Alter a Role to Add Time-based Constraints 294 Dropping a Time-based Restriction 294 Auditing 294 Viewing the Database Server Log Files 295 Encrypting Data and Security Best Practices for Roles and Privileges 848 Creating New Roles (Users) 849 Altering Role Attributes 849 Role Membership 850 Managing Object Privileges 851 Encrypting Data 854 Protecting Passwords

Level 506 Setting Parameters at the Database Level 0 Setting Parameters at the Role Level 507 Setting Parameters at the Role Level 0 Setting Parameters in a Session 507 VMware Greenplum v6.18 Documentation Security Best Practices for Roles and Privileges 658 Creating New Roles (Users) 658 Altering Role Attributes 659 Role Membership 660 Managing Object Privileges 661 Simulating Row Level Access Control 663 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 Encryption

Level 441 Setting Parameters at the Database Level 0 Setting Parameters at the Role Level 442 Setting Parameters at the Role Level 0 Setting Parameters in a Session 442 Setting Parameters in a Session Segment Failures 0 To recover with mirroring enabled 461 To return all segments to their preferred role 461 To recover from a double fault 462 To recover without mirroring enabled 463 Recovering a Failed Security Best Practices for Roles and Privileges 590 Creating New Roles (Users) 590 Altering Role Attributes 591 Role Membership 592 Managing Object Privileges 593 Simulating Row Level Access Control 595

522 Encrypting Client/Server Connections 523 Configuring Database Authorization 524 Access Permissions and Roles 524 Managing Object Privileges 525 About Object Access Privileges 525 About Password by Time 529 Example 1 – Create a New Role with Time-based Constraints 530 Example 2 – Alter a Role to Add Time-based Constraints 530 Excample 3 – Alter a Role to Add Time-based Constraints 531 Dropping Best Practices for Roles and Privileges 1066 Creating New Roles (Users) 1067 Altering Role Attributes 1067 Role Membership 1068 Managing Object Privileges 1069 Simulating Row Level Access Control 1072

Level 515 Setting Parameters at the Database Level 0 Setting Parameters at the Role Level 516 Setting Parameters at the Role Level 0 Setting Parameters in a Session 516 Setting Parameters in a Session Security Best Practices for Roles and Privileges 667 Creating New Roles (Users) 667 Altering Role Attributes 668 Role Membership 669 Managing Object Privileges 670 Simulating Row Level Access Control 672 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 Encryption

493 Encrypting Client/Server Connections 494 Configuring Database Authorization 495 Access Permissions and Roles 495 Managing Object Privileges 495 About Object Access Privileges 496 About Password by Time 499 Example 1 – Create a New Role with Time-based Constraints 501 Example 2 – Alter a Role to Add Time-based Constraints 501 Excample 3 – Alter a Role to Add Time-based Constraints 502 Dropping Best Practices for Roles and Privileges 1035 Creating New Roles (Users) 1036 Altering Role Attributes 1036 Role Membership 1037 Managing Object Privileges 1038 Simulating Row Level Access Control 1041

517 Encrypting Client/Server Connections 518 Configuring Database Authorization 519 Access Permissions and Roles 519 Managing Object Privileges 519 About Object Access Privileges 520 About Password by Time 523 Example 1 – Create a New Role with Time-based Constraints 525 Example 2 – Alter a Role to Add Time-based Constraints 525 Excample 3 – Alter a Role to Add Time-based Constraints 526 Dropping Best Practices for Roles and Privileges 1053 Creating New Roles (Users) 1053 Altering Role Attributes 1054 Role Membership 1055 Managing Object Privileges 1056 Simulating Row Level Access Control 1058

420 Encrypting Client/Server Connections 421 Configuring Database Authorization 421 Access Permissions and Roles 421 VMware Tanzu Greenplum 6 Documentation VMware, Inc 19 Managing Object Privileges by Time 426 Example 1 – Create a New Role with Time-based Constraints 427 Example 2 – Alter a Role to Add Time-based Constraints 427 Excample 3 – Alter a Role to Add Time-based Constraints 427 Dropping Security Best Practices for Roles and Privileges 889 Creating New Roles (Users) 890 Altering Role Attributes 890 Role Membership 891 Managing Object Privileges 892 Simulating Row Level Access Control 894

497 Encrypting Client/Server Connections 498 Configuring Database Authorization 499 Access Permissions and Roles 499 Managing Object Privileges 499 About Object Access Privileges 500 About Password by Time 503 Example 1 – Create a New Role with Time-based Constraints 505 Example 2 – Alter a Role to Add Time-based Constraints 505 Excample 3 – Alter a Role to Add Time-based Constraints 505 Dropping Best Practices for Roles and Privileges 1021 Creating New Roles (Users) 1022 Altering Role Attributes 1022 Role Membership 1024 Managing Object Privileges 1024 Simulating Row Level Access Control 1026

495 Encrypting Client/Server Connections 496 Configuring Database Authorization 497 Access Permissions and Roles 497 Managing Object Privileges 497 About Object Access Privileges 498 About Password by Time 501 Example 1 – Create a New Role with Time-based Constraints 503 Example 2 – Alter a Role to Add Time-based Constraints 503 Excample 3 – Alter a Role to Add Time-based Constraints 503 Dropping Best Practices for Roles and Privileges 1016 Creating New Roles (Users) 1017 Altering Role Attributes 1017 Role Membership 1019 Managing Object Privileges 1019 Simulating Row Level Access Control 1021