Not quite as easy as deploying the sql as connecting locally I’ve been using my own credentials. For an azure connection I need to:
- Create a database role and grant exec on the stored procs to that role.
- Create a new database login
- Put the database login in the role.
Why don’t I just use the “sa” password.
Well – least privilege – a good security practice.
No comments:
Post a Comment