Connecting to Greenplum®
Can I connect to the DB via SSH and get superuser permissions?
No, you cannot connect via SSH, nor can you get superuser permissions. This is done for the sake of security and user cluster fault tolerance because direct changes inside hosts can render them completely inoperable. However, you can connect to the DB as an admin user with the mdb_admin
role. The privileges it has match those of the superuser. For more information, see The mdb_admin role instead of a superuser.
How can I access a running DB host?
You can connect to Managed Service for Greenplum® databases using standard DBMS methods.
Learn more about connecting to clusters.
How do I set up user authentication?
You can set up user authentication in Managed Service for Greenplum® using rules.
For more information, see User authentication.
Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.