tailieunhanh - Microsoft SQL Server 2000 Weekend Crash Course phần 7

Đọc bẩn đề cập đến khả năng đọc các bản ghi đang được sửa đổi, kể từ khi dữ liệu trong quá trình bị thay đổi, đọc bẩn có thể dẫn đến kết quả không thể đoán trước. Phantom đọc đề cập đến khả năng | 224 Saturday Evening Each server participating in replication has to be assigned the role of Publisher Distributor and or Subscriber. It is possible for a server to perform more than one role at a time. The two main types of subscription are Pull subscriptions and Push subscriptions. The first type is initiated by the Subscriber the second by the Publisher. Quiz Yourself 1. What is the main purpose of replication 2. Describe the roles of the Publisher Distributor and Subscriber. 3. What are the three different types of replication 4. What are the advantages and disadvantages of using a central publisher with remote distributor replication model 5. What is the difference between Pull subscriptions and Push subscriptions 6. How do you monitor the replication process SESSION 20 User Management Session Checklist Setting up a user account Managing user permissions Managing a multiuser environment 30 Min. In this session you learn how to set up and administer user accounts and manage access permissions for the database object. I also introduce you to some of the considerations involved in setting up and administering multiuser environments. To Go __ Setting up a User Account Sooner or later you will have to allow someone other than yourself to connect to your SQL Server and you have to make sure that he or she has just enough rights to do his or her job no more no less. 226 Saturday Evening I ll discuss security issues in depth in Session 28. Roles SQL Server uses roles. Two layers of access exist access to the SQL Server and access to a database object within the server. Each can be configured separately. While I will discuss SQL Server roles in greater detail in Session 28 it will be beneficial for you to learn about some fixed database roles namely these four Public Essentially anyone who has enough rights to connect to the database the lowest role possible in terms of database permissions. db_owner Someone who has full rights to this .