none
DB Schema Permission RRS feed

  • Question

  • Hello,

    After creating Database in Data Warehousing, need to create different schema based on different applications so we can store application related objects and data into one schema. Our Application/objects are in different server which will be loading into DW server DB.

    We have HR, Finance and Employee applications which are stored in a databases like HRDB, FinanceDB and EmployeeDB.

    We have windows AD group created and assign the needed privileges in Development for all the developers.

    So each user are part of that windows AD group . After creating DBs, we need to create Schema so we can copy the few objects into application based schema.Ex. HR tables will go in HR Schema, Finance related tables will go in FINANCE schema and Employee related tables will go in EMP Schema from there respected tables.

    When i create the Schema using following sql, is it go under my login as i am connecting through my windows authentication?Do i need to assign any Role or user privileges to this schema?My windows login is part of Developers windows group.

    USE EmployeeDetails

    GO

    CREATE SCHEMA EMP_SCHEMA

    CREATE SCHEMA HR_SCHEMA

    CREATE SCHEMA FINANCE_SCHEMA

    What else need to follow?

    Sunday, June 23, 2019 4:40 PM