Make sure you are logged in as yourself while trying to do this. Create a role and demonstrate its use. A role allows you to create privileges specific to a certain group. Grant the manager with the select privilege to the student table. Grant manager access to the new user you created earlier.
Views are useful in several instances.
They are useful when you need to run the same query repeatedly or when you need to limit access to your data. A view is basically a way to name a query. This will require linkages to three tables. Display the output from this query. Now we are going to create a view that does the same thing.