PostgreSQL provides default roles that provide access to privileged capabilities and information.

With the newly-defined ibm-cloud-admin role as one of the default roles in IBM Cloud® Hyper Protect DBaaS, database admins have more privileges and can grant roles to other users or roles.

What is the ibm-cloud-admin role?

When you create a Hyper Protect DBaaS for PostgreSQL service instance in IBM Cloud, you are the admin user and are automatically given the ibm-cloud-admin role.

Why do I need this role?

Hyper Protect DBaaS for PostgreSQL, as a highly secure and managed cloud database service, doesn’t grant database admins the super user role. However, super user privileges are required for many operations. The ibm-cloud-admin role is designed to support you to complete the operations without the super user role.

What can I do with this role?

Resources that are created by users in the ibm-cloud-admin role are not accessible by other users, unless they are granted required permissions.

The biggest difference between the ibm-cloud-admin role user and other users you add to your service instance is the pg_monitor and pg_signal_backend roles. The pg_monitor role provides a set of permissions for monitoring the database server. The pg_signal_backend role provides the ability to send signals to cancel queries and connections initiated by other users except database superusers.

You can grant these two roles to other users or roles.For example, you can grant the pg_monitor role to user deb. You can also grant pg_monitor to all the users with the admin role.

For more information and detailed instructions, see Managing users, roles, and privileges.

More about IBM Cloud Hyper Protect DBaaS

IBM Cloud Hyper Protect DBaaS offers a highly secure and managed databases — including PostgreSQL and MongoDB Enterprise Server — and provides a high level of data confidentiality for your sensitive data in the IBM Cloud.

Go to the IBM Cloud Catalog to try out the 30-day free plan for Hyper Protect DBaaS. You can choose between two database options:

Check out the Getting Started with IBM Cloud Hyper Protect DBaaS and Bring Your Own Key to IBM Cloud Hyper Protect DBaaS videos in the IBM Demos Collection.

Consult the Hyper Protect DBaaS for PostgreSQL documentation or the Hyper Protect DBaaS for MongoDB documentation for details on how to get started.

More from Announcements

IBM named a Leader in Gartner Magic Quadrant for SIEM, for the 14th consecutive time

3 min read - Security operations is getting more complex and inefficient with too many tools, too much data and simply too much to do. According to a study done by IBM, SOC team members are only able to handle half of the alerts that they should be reviewing in a typical workday. This potentially leads to missing the important alerts that are critical to an organization's security. Thus, choosing the right SIEM solution can be transformative for security teams, helping them manage alerts…

IBM and MuleSoft expand global relationship to accelerate modernization on IBM Power 

2 min read - As companies undergo digital transformation, they rely on APIs as the backbone for providing new services and customer experiences. While APIs can simplify application development and deliver integrated solutions, IT shops must have a robust solution to effectively manage and govern them to ensure that response times and costs are kept low for all applications. Many customers use Salesforce’s MuleSoft, named a leader by Gartner® in full lifecycle API management for seven consecutive times, to manage and secure APIs across…

IBM Consulting augments expertise with AWS Competencies: A win-win for clients 

3 min read - In today's dynamic economic landscape, businesses demand continuous innovation and speed of execution. At IBM Consulting®, our unwavering focus on partnerships and shared commitment to delivering enterprise-level solutions to mutual clients have been core to our success.   We are thrilled to announce that IBM® has recently gained five competencies from Amazon Web Services (AWS) in vital domains including Cloud Operations, Internet of Things (IoT), Life Sciences, Mainframe Modernization, and Telecommunications. With these credentials, IBM further establishes its position as a…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters