August 18, 2005 at 8:49 am
Hello,
When creating an application roll in the Enterprise Manager,,
Is this utilized in the connectionstring , in the vb.net code?
If not what is the sole purpose of the application roll from an experienced perspective.
Erik..
Dam again!
August 18, 2005 at 2:51 pm
Creating an application role enables you to set security context at 1 point for an application and not for each individual user using the app.
From Books Online
"The security system in Microsoft® SQL Server™ is implemented at the lowest level: the database itself. This is the best method for controlling user activities regardless of the application used to communicate with SQL Server. However, sometimes security controls must be customized to accommodate the special requirements of an individual application, especially when dealing with complex databases and databases with large tables.
Additionally, you may want users to be restricted to accessing data only through a specific application (for example using SQL Query Analyzer or Microsoft Excel) or to be prevented from accessing data directly. Restricting user access in this way prohibits users from connecting to an instance of SQL Server using an application such as SQL Query Analyzer and executing a poorly written query, which can negatively affect the performance of the whole server."
August 18, 2005 at 3:00 pm
Thanks
Dam again!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply