May 17, 2008 at 7:46 am
Hi, we have a database on sql server 2000 which is accessed through an odbc data link and the roles are standard ones (not application roles) we can't modify that roles cause it results too many changes in the application.
My question is : is there a solution to prevent users access through another application (excel, access,delphi,... ) or at least to lock this access on "read only" mode ?
Thanks
May 19, 2008 at 2:53 pm
You can restrict what someone can do in a database by granting them permissions on objects or by assigning them to fixed database roles that already have certain permissions. If you want to allow read-only access to all tables, just assign the user to the db_datareader fixed database role.
I'm not clear why you mentioned roles. Are talking about fixed database roles (db_datareader, etc.) or custom roles that have been created in the database.
Greg
May 19, 2008 at 3:01 pm
If the users are coming into the database as their Windows accounts, or if they know their SQL Server logins with respect to an application that uses them, the short answer is no. Short of going to application roles, or using a service account (that can be protected from the user), you're not going to be able to change their security context based on the application used to connect.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply