Link to home
Start Free TrialLog in
Avatar of yrcdba7
yrcdba7Flag for United States of America

asked on

full permission for store procedures sql 2005

Dear Expert,

How to give full permission for store procedure in sql 2005.
For example,

user: ABC\lynn
for full store procedure permission, I should go to sproc, property and
click user, check all of grant for full permission?
Please advise.

Thanks,
Lynn
Avatar of Lowfatspread
Lowfatspread
Flag of United Kingdom of Great Britain and Northern Ireland image

do you just want them to be able to use the procedure?

Grant Exec spname to user


full (create/drop/alter and run)

grant all spname to user
ASKER CERTIFIED SOLUTION
Avatar of Aaron Shilo
Aaron Shilo
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks for the reminder