What sql server permissions etc for linked tables, sprocs

[mat]

I'm not much of a hand with networks. Can someone lay out for me what a
normal security setup would be to allow for linked tables to a system
dsn with read/write and execute perms on stored procedure (via
passthrough queries)? I've configured a number of installations
successfully but I don't really have a great understanding of what I'm
doing and probably there is a better way.

The users will be domain members so windows auth is good. I usually
create a new domain group called myappusers, and the users that become
members of that group are the ones that use the application.

Then, what are the permissions needed by that group to link to the db
via the system dsn and to execute stored procedures?

 

[Stefan Hoffmann]

hi Mat,

The users will be domain members so windows auth is good. I usually
create a new domain group called myappusers, and the users that become
members of that group are the ones that use the application.

You need to create a SQL Server Login for that group.

Then, what are the permissions needed by that group to link to the db
via the system dsn and to execute stored procedures?

The easiest: db_datareader and db_datawriter for your database.


mfG
--> stefan <--

 

[Paul Shapiro]

I think you also need to specifically grant that domain group execute
permissions on the stored procedures.

 

[Stefan Hoffmann]

hi Paul,

I think you also need to specifically grant that domain group execute
permissions on the stored procedures.

Yes, that's true. I missed that part int the op.


mfG
--> stefan <--