Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Sử dụng một máy chủ cố định vai trò quản trị một công cụ cơ sở dữ liệu máy chủ như SQL Server có thể là một quá trình tốn nhiều thời gian. nhiệm vụ hành chính bao gồm sao lưu dữ liệu, thêm người dùng mới, sửa đổi các bảng và quan điểm | 11.7 Use a Fixed Server Role Managing a server database engine such as SQL Server can be a time-consuming process. Administrative tasks include backing up the data adding new users modifying tables and views and so on. Most SQL Server administrators find it useful from time to time to permit other people to perform these tasks. Assigning other people tasks such as backing up the databases or administering security allows the system administrators to devote more time to other responsibilities. As a system administrator I am overwhelmed by the administrative tasks that are required to keep several databases operating efficiently. There s too much to do between database administration adding new users performing backups and other tasks. I d like to be able to allow an assistant to assume some of these responsibilities so that I won t have to be personally involved in performing these tasks. However I m not looking forward to assigning various permissions to all of my administrative assistants. For instance some people are to be designated as security administrators whereas others will be responsible for updating table designs. Technique SQL Server supports the notion of fixed server roles that define certain administrative profiles. Each fixed server role is accompanied by the appropriate permissions to perform the administrative tasks that are associated with the role. Enterprise Manager provides all the dialog boxes that are necessary to assign user accounts to the fixed server roles that SQL Server recognizes. It is important to note that each fixed server role is global within SQL Server. This means for instance that the dbcreator fixed server role is able not only to create new databases but also to make changes to existing databases in SQL Server. SQL Server recognizes eight fixed server roles sysadmin. This is the most powerful fixed server role. Members of this role are able to perform all the tasks included with the other roles. serveradmin. The serveradmin .
