What sql server permissions etc for linked tables, sprocs

  • Thread starter Thread starter mat
  • Start date Start date
M

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?
 
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.
Click to expand...
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?
Click to expand...
The easiest: db_datareader and db_datawriter for your database.


mfG
--> stefan <--
 
I think you also need to specifically grant that domain group execute
permissions on the stored procedures.
 
hi Paul,

Paul said:
I think you also need to specifically grant that domain group execute
permissions on the stored procedures.
Click to expand...
Yes, that's true. I missed that part int the op.


mfG
--> stefan <--
 
Back
Top