Chapter 6 PROGRAMMING SQL SERVER 2000 377 Application
Chapter 6 PROGRAMMING SQL SERVER 2000 377 Application Roles One of the handy features of this security model is the application role. An application role is similar to other roles, but the role has no members associated with it. The GRANT and REVOKE statements work the same way with an application role as with any other role. To create an application role, use the sp_addapprole system-stored procedure: sp_addapprole AppRoleName , Password Yes, there is a password. To activate the application role for a given connection, the connection must execute another stored procedure, sp_setapprole, this way: sp_setapprole AppRoleName , Password This stored procedure causes the connection executing the stored procedure to acquire the permissions granted to the application. In other words, the application has to run that stored procedure and send the password to invoke the correct permissions. At the point that sp_setapprole is used, any roles, permissions, or users associated with the connection are gone, and only the permissions assigned to the application role are valid. An encryption option can be specified with the sp_addapprole command, which encrypts the password before it is sent across your network. To do this, use sp_setapprole as follows: sp_setapprole AppRoleName , {Encrypt N Password }, odbc The little odbc at the end specifies that the password should be encrypted using the standard ODBC encryption function. Otherwise, no encryption will be used. Why all the bother with application roles? There are two reasons. First of all, you can set up an application role for a user application, and give the role access to all the tables and other objects it needs to access, but users who try to log in to SQL Server with Query Analyzer do not necessarily have a valid password to use to get the same level of access, which prevents them from modifying data incorrectly or running queries that may impede overall server performance.
If you looking for unlimited one inclusive web hosting plan please check web hosting plan website.