April 15, 2010 at 2:31 pm
I have several analysts that need to be able to run Stored Procedures from time to time. Right now they have SYSADMIN access and I don't want them to have it. What type of access do they need to have to be able to run Stored Procedures? Any help will greatly appreciated.
April 19, 2010 at 2:28 am
If it is the case that there are only a handful of Stored Procedures the analysts are going to need to run, then it is worth considering giving them basic rights and simply giving them exec permissions against individual Stored Procedures.
April 19, 2010 at 2:47 am
hi,
U can give permissions for single user to one or more objects. Please go through the wizard with the following steps.
Go To security folder under Databadse.
Right click on selected Use -> select properties ->Choose securabl tab.. then click on search button...
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply