- 🌱 I’m currently learning Blazor, Laravel
- 💬 Ask me about System Design, SQL, Dotnet Core, Web Development, Angular, ReactJS
# Managing PostgreSQL users and roles
With PostgreSQL, you can create users and roles with granular access permissions. The new user or role must be selectively granted the required permissions for each database object. This gives a lot of power to the end user, but at the same time, it makes the process of creating users and roles with the correct permissions potentially complicated.
PostgreSQL lets you grant permissions directly to the database users. However, as a good practice, it is recommended that you create multiple roles with specific sets of permissions based on application and access requirements. Then assign the appropriate role to each user. The roles should be used to enforce a least privilege model for accessing database objects. The master user that is created during Amazon RDS and Aurora PostgreSQL instance creation should be used only for database administration tasks like creating other users, roles, and databases. The master user should never be used by the application. [^1]
Forked from Rolias/Angular-AlbumStoreProductPage
JavaScript
Forked from vijinho/ISO-Country-Data
ISO Country data in JSON and CSV format.
Forked from gothinkster/laravel-realworld-example-app
Exemplary real world backend API built with Laravel
PHP
Forked from bhaveshpatel200/ng-datatable
ng-datatable is a powerful component for creating dynamic and customizable data tables. It supports large amounts of data, sorting, pagination, and filtering and highly customizable
TypeScript