I'm looking to setup a user account in Sql Server 2000 in the most secure manner. The criteria is as follows:
- No access to the master database (
- DB Read Permission (
- DB Write Permission (
- DB Execute Permission for sprocs (
To me this seems like a pretty straight forward setup and that it ought to be a standard scheme. Running through a couple articles show that it isn't and that granting sproc execute permissions is less than easy.
Is there an easier way to grant sproc execute permission? Is there a catch all scheme that provides secure database access? Am I tracking on the right path?