tailieunhanh - Create Windows NT/2000 Groups

11,2 Tạo Windows Groups NT/2000 Windows 2000 công nhận người dùng cá nhân cũng như các nhóm chức năng. Bạn có thể, ví dụ, thiết lập một nhóm gọi là tiếp thị hoặc bán hàng, và sau đó thêm người dùng mới vào máy tính. | Create Windows NT 2000 Groups Windows 2000 recognizes individual users as well as functional groups. You can for instance set up a group called Marketing or Sales and then add new users to the computer. In addition each user can be added to any of the groups that you ve created. Therefore you might have a marketing manager who belongs to both the Marketing and Management groups. One advantage of using groups is that SQL Server automatically recognizes the registered Windows users. SQL Server is tightly integrated with Windows security and you are able to use this integration as you set up SQL Server security. This means for instance that you can provide the marketing group with access to tables and stored procedures that are related to marketing data yet deny the salespeople access to those same tables and procedures. The marketing manager mentioned earlier in this chapter is able to work with marketing and management data such as employee human resources data . Because you are treating multiple users as a single group the administrative effort is considerably less than if you had gone to the trouble of providing access to each individual user. As you ll soon see treating users as members of groups greatly simplifies the security administration task. Handling individual users is a real hassle. In large installations with hundreds of users you spend inordinate amounts of time managing SQL Server security on a user-by-user basis. Instead you d like to use Windows groups to add groups of users to the database. Technique Use the Administrative Tools in the Control Panel to create groups and add the users you ve created to those groups. Steps Most often users are arranged into logical groupings. For instance all the people in the marketing department are likely to belong to a group named Marketing. Similarly managers probably belong to a Management group. In this section you ll learn how to specify the groups on your computer and add the user accounts you ve .