Maintain role permissions on new objects

If you have a schema where you want developers to have read-only access to all tables, but you don’t want to grant select any, keeping up with new tables can be a challenge.  We wrap the following into a script that runs a few times a day.  We have a DBA schema in each database [...]

Read Full Post »