Learn how to :
1- Install Postgresql 10+ from a precompiled package, and prepare the databases cluster.
2- Create schemas, databases and roles(users).
3- Learn the basic permissions you can assign to any user in a schema and how these permissions acts on any databases.
4- Learn the more in depth user’s permissions .
5- Add,remove and alter permissions on database users.
6- What the scope of each permission in a database.
This course will teach you about the fundamentals of the permissions that you need to control who can access to your database and who can do changes on the database both in database structure as well as the data content of the tables .
The database administrators will handle the manager role that will assign all permissions to other roles using the database .
Thos permission will be assigned at the time of creating the database ,or as well as at the times when creating any new role that uses the database.
Admin roles will have the right to grant his/her permissions to other roles .
Superuser has all privileges and can do all actions on the database he owns.
How the Permissions types and assigned roles can be assigned by the admin…or the superuser . .
