» Transact SQL
» Schemas (RSS)
Sorry, but there are no more tags available to filter with.
I use schemas to simplify granting permissions. For tables and views, I have three schemas:
Data, the actual data my customers need. Can only be modified via sprocs.
Staging, only visible to data loaders and devs. Full privileges on INSERT?UPDATE/DELETE for those who see it.
Config, the configuration data used in loads, only visible to data ...