![]() ![]() Also, the server admin account can be used to create less privileged users and roles that have access to individual databases and schemas. ![]() The server admin user account can be used to create additional users and grant those users into the azure_pg_admin role. LOGIN, NOSUPERUSER, INHERIT, CREATEDB, CREATEROLE, REPLICATION In Azure Database for PostgreSQL, the server admin user is granted these privileges: The PostgreSQL engine uses privileges to control access to database objects, as discussed in the PostgreSQL product documentation. Since this service is a managed PaaS service, only Microsoft is part of the super user role. However, the server admin account is not part of the azure_superuser role. Your server admin user is a member of the azure_pg_admin role. You can see these roles by running the command: SELECT rolname FROM pg_roles The Azure Database for PostgreSQL server is created with the 3 default roles defined. Since the server admin user name is a custom name, you can locate the chosen server admin user name from the Azure portal. For more information, you can follow the Quickstart to see the step-by-step approach. When you first created your Azure Database for PostgreSQL, you provided a server admin user name and password. If you would like to learn about how to create and manage Azure subscription users and their privileges, you can visit the Azure role-based access control (Azure RBAC) article or review how to customize roles. This article describes how you can create users within an Azure Database for PostgreSQL server. Azure Database for PostgreSQL - Single Server
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |