??????mysql?д??????Schema????????Database??Ч????????????????????sqlserver??orcal???????Ч????????????????????????mysql??schema<==>database;

??????????е?user??schema??????
???????????????????????е?user??schema???????????????????????е?user??schema????
??????sqlserver2000?У????????????user??schema??????????????????????????????????user??schema???????????????????????sqlserver2005?????????????????user??schema?????????
?????????????????????????database??schema??table???У??У?user???????database????????????????????????????schema?????е???????schema???????????table????????????schema?е????table????????????????????У?????????????????????????????????鰡????????????ú??????????table??????ú???к??????????????д洢?????????????table??????????????????????????λ?????user?????schema?????????????schema??????object????????user???????user???????????????user?????????????????????????в????????????????????????в?????????????schema????????????????????????????user?????schema???????????????仰?????????????????????????????????????????е????ж?????????????????????????????????????????????????????????????????????Щ?????????????????????????е??????????????user?????????????????????????????Щ????????????read-only?????????????????????????е???????r/w?????????????user?????????role???
??????sqlserver2000?У???????????????????д????????Bosco??????????????????????????schema??Bosco????schema???????user?????????????????????????????schema?????
??????sqlserver2005?У?????????????????sp_adduser?洢??????????????????sqlserver2005????????????????????????schema?????????洢????????????????????????????????????μ?DDL????create user??create schema?????????????sqlserver2005?У?????????create user??????????????????????????????????????????schema???????schema???????????????????????????schema???dbo schema??dbo????schema??????????????????????????????????schema??????￡????????????н????Щ??????????create table???????????????????schema???????????????÷????????dbo????schema???????????????????????????schema?????????????в?????????????schema????У????統(tǒng)????????login1????????????schema?login1???????????????????????????login1???schema????е???????????????????????????????????Σ?????dbo?????schema???????????????????в?????dbo?????????user??????ɡ?
??????sqlserver2005?д????????????????????Щschema????????????????????schema?У?dbo??INFORMATION_SCHEMA??guest??sys?????????Щ???schema????
??????????????????????sqlserver2005?е???洢????sp_adduser???????user?????sqlserver2005?????????????????????????????schema?????????????????????create table a??????????????schema?????????a????????????schema???????????????????????
????1.???????????????????????????select current_user?????????????schema??????????????????????????a??????????????schema???
????2.??????????????????????????schema?????????user???????????????????????????????????schema???????a??????????????dbo schema???????????????????????schema???????????????????????schema????????????????????????????????schema??????????????????????????κι?????
????3.??????????a?????????????schema?????????a???????????????schema????????????
?????????????????????????????????????????select current_user???????????????)??????schema??????￡?????????create table a??????a???????dbo schema?????????????dbo schema??????????????a????????ж?dbo schema??????????????д??????????????a??????????????????????????login??user??role??schema?????????????????????????????????????????????????????Χ??????????????????????????????????????????????????????????????????????Schema?????