THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Transact SQL » Schemas   (RSS)
Sorry, but there are no more tags available to filter with.
  • How I use schemas.

    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 ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on May 18, 2010
Privacy Statement