Application Security
As mentioned previously, you will find certain circumstances when you don't want your users to access the data through any application other than the one that you create. In other words, you want to keep users from viewing or modifying data using Microsoft Access or Crystal Reports. With the release of SQL Server 7.0, Microsoft provides a way for developers to essentially lock up a database, with the developer's application as the only key. This new addition to SQL Server is an application role. The main functionality provided to you by an application role is as follows:
Application roles don't contain any users. Instead, when a user logs in to the database through a specific application, the application invokes the application ...
Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
