How I use schemas.

Posted by Alexander Kuznetsov on SQL Blog See other posts from SQL Blog or by Alexander Kuznetsov
Published on Tue, 18 May 2010 18:22:00 GMT Indexed on 2010/05/18 18:41 UTC
Read the original article Hit count: 790

Filed under:
|
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 loaders and devs. Can only be modified via sprocs. For sprocs/UDFs I have the following schemas: Readers Writers ETL ConfigReaders ConfigWriters Also I have dbo...(read more)

© SQL Blog or respective owner

Related posts about schemas

Related posts about Transact SQL