permissions granted to an application intead of a user

I have an application that talks to an access db located on a 2000 server. I would like grant permissions to the application instead of a specific user. Any help would be great...

Such capability is not available - permissions are grantable to accounts, not to applications.

Thanks
Laurentiu

|||

I am including a link to a related entry in this forum where we have a detailed discussion on this topic:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=786513&SiteID=1

I hope this information will be useful.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

|||

let me restate:

the db is on a mapped drive on the 2000 server.

i want the prgm to have access to it but not to the general public.

i need a way to limit access to myself and the prgm only....

i have admin rights and would like to give the prgm the same...

|||

Answer is the same - Windows security works by assigning permissions to users - permissions cannot be assigned to applications.

You should read the post that Raul pointed out. You can attempt to use application roles or have the application connect with specific credentials to the database, but a smart user can reverse-engineer the application and figure out how to connect directly to the database, hence there is no security guarantee of the type you seek.

Thanks
Laurentiu