We have a production system with one main user for the database, this user has all priveledges that allow him to select, update, insert and delete.
I want to create a safe user that everyone can log into the database as. This user must only have select priveleges and that is all.i.e. Not be able to change anything, add anything or delete.
How should I go about this?