對於新版SQL Server沒有用途, 效果與dbo一樣
Those default schemas such as db_datareader, db_datawriter etc. are for backwards compatibility reasons.
In SQL Server 2000, schema is as the same as the user and the schema must be created by the corresponding user.
So if migrated from 2000, it must be match each other otherwise there is an error.
But the schema and fixed roles are not necessary to be there.
The database fixed roles such as “db_datareader” are owned by dbo.
But the schemas are ownded by corresponding roles. Both of the above are re-configurable.
“db_datareader” and “db_datawriter” can perform SELECT/INSERT/DELETE/UPDATE operation on any table or view with any schema which due to “Implicit Permissions” of fixed roles.
But in SSMS, for an user with db_datareader role, he can only view the tables/views with the schema db_datareader or dbo or other schemas owned by db_datareader or dbo or the user itself.
SQL-Server–使用另一個Windows-Account操作SSMS-錯誤訊息--請輸入用於cprogram-filesql-server-management-studio-18common7idessmsexe" title="SQL Server–使用另一個Windows Account操作SSMS, 錯誤訊息 : 請輸入用於c:\program file\sql server management studio 18\common7\ide\ssms.exe