Search


	Podcast:		voiceofthedba's podcast
	Episode:		Schema Security
	Category:		Technology
	Duration:		00:02:27
	Publish Date:		2019-02-28 20:00:00
	Description:		How many of you grant access to schemas in your databases? I'm curious because I slowly am starting to see more and more people using schemas in their designs and not defaulting every object to "dbo". That was the default action for many developers for years, and it's still a habit of mine. Without SQL Prompt to add the schema to my queries, I'd still be producing code that followed that practice. Schemas exist to allow some separation of different types of objects. In early versions of SQL Server, we didn't have schemas, but considered the third of four part naming to be the owner. In other RDBMSes, the use of a schema was to allow grouping and separation of different objects. This was also, and still is, a security boundary that helps ensure that authorized users can be easily limited to data access for certain objects. Read the rest of Schema Security
	Total Play:		0