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.

Categories

More from Announcements

IBM TechXchange underscores the importance of AI skilling and partner innovation

3 min read - Generative AI and large language models are poised to impact how we all access and use information. But as organizations race to adopt these new technologies for business, it requires a global ecosystem of partners with industry expertise to identify the right enterprise use-cases for AI and the technical skills to implement the technology. During TechXchange, IBM's premier technical learning event in Las Vegas last week, IBM Partner Plus members including our Strategic Partners, resellers, software vendors, distributors and service…

Introducing Inspiring Voices, a podcast exploring the impactful journeys of great leaders

< 1 min read - Learning about other people's careers, life challenges, and successes is a true source of inspiration that can impact our own ambitions as well as life and business choices in great ways. Brought to you by the Executive Search and Integration team at IBM, the Inspiring Voices podcast will showcase great leaders, taking you inside their personal stories about life, career choices and how to make an impact. In this first episode, host David Jones, Executive Search Lead at IBM, brings…

IBM watsonx Assistant and NICE CXone combine capabilities for a new chapter in CCaaS

5 min read - In an age of instant everything, ensuring a positive customer experience has become a top priority for enterprises. When one third of customers (32%) say they will walk away from a brand they love after just one bad experience (source: PWC), organizations are now applying massive investments to this experience, particularly with their live agents and contact centers.  For many enterprises, that investment includes modernizing their call centers by moving to cloud-based Contact Center as a Service (CCaaS) platforms. CCaaS solutions…

See what’s new in SingleStoreDB with IBM 8.0

3 min read - Despite decades of progress in database systems, builders have compromised on at least one of the following: speed, reliability, or ease. They have two options: one, they could get a document database that is fast and easy, but can’t be relied on for mission-critical transactional applications. Or two, they could rely on a cloud data warehouse that is easy to set up, but only allows lagging analytics. Even then, each solution lacks something, forcing builders to deploy other databases for…