![]() ![]() The testuser is a normal user that hasĪccess to the database “userdb” that is created for testing purposes.How to List Databases Using the psql command line tool | Beekeeper Studio Beekeeper Studio menuĮxperience a truly modern SQL editor that really sweats the details. The primary user is used for replication between primary and replicas. The postgres user will be the admin user for the database instance. Superuser, Create role, Create DB, Replication, Bypass RLS The default PostgreSQL instance installation via the PostgreSQL Operator comes with the following users: Role name In the context of the PostgreSQL Operator, the “PostgreSQL User” is any person interacting with the PostgreSQL database using database specific connections, such as a language If this is you, please skip to section 2.3.1 where we cover configuring and installing PGO. Their rights to carry out operations using the PGO CLI tool is governed by PGO Roles(discussed in moreĭetail later) configured by the Platform Administrator. The Crunchy PostgreSQL Operator service in Kubernetes via the PGO CLI tool. The Platform User is anyone that is interacting with Testing out functiontionality will be easier, if you want to limit functionality to specific actions section 2.4.5 covers roles. While admin rights are not required for a typical user, Platform Userįor purposes of this User Guide, a “Platform User” is a Kubernetes system user and has PostgreSQL Operator admin rights. That installation can be on RedHat OpenShift 3.11+, Kubeadm, or even ![]() Will be responsible for managing the installation of the Crunchy PostgreSQL Operator service in Kubernetes. PostgreSQL Operator admin rights are not required, it is helpful to have admin rights to be able to verify that the installation completed successfully. Platform Administratorįor purposes of this User Guide, the “Platform Administrator” is a Kubernetes system user with PostgreSQL Administrator privileges and has PostgreSQL Operator admin rights. The PostgreSQL User has access to a PostgreSQL Instance or Cluster but must be granted explicit permissions to perform actions in PostgreSQL based upon their role membership.Īs indicated in the above table, both the Operator Administrator and the PostgreSQL Administrators represent privilege users with components within the PostgreSQL Operator. ![]() the “postgres” user) and can perform all the actions that a PostgreSQL superuser is permitted to do, which includes adding additional PostgreSQL Users, creating databases within the cluster. The PostgreSQL Administrator is the equivalent of a PostgreSQL superuser (e.g. PostgreSQL Administrator(Privileged Account) A Platform User only receives a permission if its is explicitly granted to them. A Platform Administrator manages the specific permissions for an Platform User specific permissions. The Platform User has access to a limited subset of PostgreSQL Operator functionality that is defined by specific RBAC rules. This user can have access to any database that is deployed and managed by the PostgreSQL Operator. The Platform Admininistrator is able to control all aspects of the PostgreSQL Operator functionality, including: provisioning and scaling clusters, adding PostgreSQL Administrators and PostgreSQL Users to clusters, setting PostgreSQL cluster security privileges, managing other PostgreSQL Operator users, and more. Platform Admininistrator (Privileged User) In installing, configuring and operating the PostgreSQL Operator as a PostgreSQL-as-a-Service capability, the following user roles will be required: RoleĪuthorized Privileges and Functions Performed Native PostgreSQL-as-a-Service infrastructure. The PostgreSQL Operator, when used in conjunction with the associated PostgreSQL Containers and Kubernetes, provides you with the ability to host your own open source, Kubernetes User & Roles User Roles in the PostgreSQL Operator ![]()
0 Comments
Leave a Reply. |