So now that we have the login and the user set up, how do we actually assign permissions? I prefer to assign permissions to roles and add users to roles which mirrors the user/groups of windows, so going down that path we have to create a role (going under Security –> Roles): CREATE ROLE [TestRole] [...]
So how do we manage permissions in a Database Project? Well the logins and users are pretty straight forward, however sadly the grants are not as intuitive as we’d like (unless you find manually editing xml documents intuitive), but the next version is supposed to be gui driven. However right now I hope you enjoy [...]
Lately I’ve been utilizing schemas more frequently in my databases, however the first time I did this in VSDBPro was a pain. The reason for this was I didn’t know how to do it, so hopefully this post will save someone else the struggles I went through. First I want to highlight the differences between [...]