creating roles in database project

Question

I`m using database project in visual studio 2013(professional).

All other thing works great, but I`m facing the issue with create user command. even I have already created user for dbproj on server with all access. Even I have only import database in database project and try to build though it showing me error.

Below command showing me error. "Create user [dbproj] for Login [dbproj]".

Please help me out...

Thanks in Advance.

And when are you getting the error (when building, while publishing, when deploying a .dacpac...)? — Keith, Jul 24 '15 at 16:59
I've ended up handling users/permissions in post-deploy scripts until MS realizes that those change from environment to environment and gives us an easier way to handle them: http://schottsql.blogspot.com/2013/05/ssdt-setting-different-permissions-per.html (not necessarily easy, but it's a one-time setup and not as hard to handle after that initial phase) — Peter Schott, Jul 24 '15 at 23:21
@Peter: Thanks Peter. I know it works fine in the post deployment script. This scripts run for some cases. Can`t understand the problem. — Ravindra Sinare, Jul 27 '15 at 07:18
Is the Build Action of the Create Login script set to "Build"? — Keith, Jul 28 '15 at 20:24

Ravindra Sinare · Accepted Answer · 2015-08-26T11:38:45.217

1

If same command I write into the postDeploymentScript then it works in my case.

edited Aug 26 '15 at 11:38

answered Aug 05 '15 at 05:34

Ravindra Sinare

675
1
9
25

creating roles in database project

1 Answers1