yrcdba7
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
thanks for the reminder
Grant Exec spname to user
full (create/drop/alter and run)
grant all spname to user