Create a windows group and add to all ad users. Then grant SELECT (whatever) permissions to that group. Specify that windows group to connect to the server in your application.
GRANT EXEC ON some_sp TO user-- Grant permission on a single procedure.
GRANT EXEC ON SCHEMA::dbo TO user-- Grant perpmission on all procedures in
the dbo schema
GRANT EXEC TO user-- Grant EXEC permission all procedures in the database.
To grant all "normal" permissions on a table
GRANT SELECT, UPDATE, DELETE, INSERT on tblname TO user
To grant user access on tables in a schema:
GRANT SELECT, UPDATE, DELETE, INSERT on SCHEMA::dbo TO user
To grant him access on all tables:
GRANT SELECT, UPDATE, DELETE, INSERT TO user
Best Regards,Uri Dimant SQL Server MVP,
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.