TAILIEUCHUNG - Create Application Roles

11,13 Tạo Application Roles Nếu như vai trò cơ sở dữ liệu cố định và vai trò cơ sở dữ liệu tùy chỉnh được không đủ, SQL Server cung cấp một loại thứ ba của vai trò cơ sở dữ liệu. | Create Application Roles As if fixed database roles and custom database roles weren t enough SQL Server provides a third category of database role. Sometimes you want users to simply start up an application and have access to SQL Server s data through the application. In these cases you don t want to have to set up logins user accounts and other security configurations to accommodate the application s users. This is the job of application roles. I have users who routinely access SQL Server through an application that I ve written in Visual Basic. I also have users who use Web pages to access the data using ASP techniques. I d like a simple and easy way to provide these users with limited access to the database but I don t want to spend a lot of time configuring SQL Server. Technique Create a SQL Server 2000 application role for these users. The application logs into SQL Server and provides the password that is required to access data. Typically application roles are severely limited in their ability to access data. Steps SQL Server provides for the creation of application roles. An application role is established to allow programs that are written in Visual Basic and other programming languages to freely access and update SQL Server data. People cannot use application roles. You cannot add users groups or other roles to an application role. The application role is not enabled until a password is provided. At runtime the user s application will provide the role s name and password to gain access to the data that is granted by the application role. The application is unable to do anything other than the permissions you established for the application role. 1. Open Enterprise Manager and expand the Northwind database s icon. 2. Right-click the Northwind database s Roles icon and select New Database Role from the shortcut menu. The New Role dialog box opens in response see Figure . Select the Application Role option button near the bottom of this dialog .

• Cơ sở dữ liệu
• công nghệ máy tính
• phần mềm
• kỹ thuật lập trình
• lập trình
• dữ liệu
• Create Application Roles
• Phần cứng máy tính
• lắp ráp máy tính
• sửa chữa máy tính
• lỗi máy tính
• hệ thống mạch máy tính
• điện máy tính
• Tài liệu máy tính