Have you ever wanted to give someone access to the database without giving away the keys to the kingdom? Do developers "accidently" drop databases on you? Can you answer the question who can see the data in this table?
Learn how to remedy these things and many more as I guide you on a quest to better securing your database through the use of permissions and roles.
We will cover:
- The basics of permissions
- What permissions there are and how to get more information about them
- What roles are and how to use them in order to make your security easier to manage
- How to figure out what permissions already exist on the database/server
- How to use roles to restrict data that a person can see in a view
- and much more