Schema Import missing GRANTs

After importing my schema, I see plenty of nice scripts for my sprocs and tables. I also see that my ROLES are created, but the mapping of roles to the sprocs is missing. I have a dbReader role that can access my query stored procedures and a dbWriter role that can access the Inderts/Updates/Deletes. somhow this relationship of GRANTS has been lost in the translation...

[373 byte] By [markdavisnohorse] at [2008-2-22]

«« Decimal Type Complications
»» Tag name from an XML

# 1

Mark,

Thank you for the comment. I think, you are talking about a known issue, but can you, please tell me whether you are using SQL 2000 or 2005.

If you want to deploy the database, the workaround for this issue is to put your grant statements in the post-deployment script under script folders.

Best Regards,

Dmitriy Nikonov

Dmitriy_Nikonov_MSFT at 2007-9-10 >

top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

# 2

I'm generating the scripts from a sql 2000 database. I'll see about moving those grants to the place you mentioned. in planning for the future, do you know where those grants will end up living when generated? If not, I'll just wait for the next rev...

markdavisnohorse at 2007-9-10 >

# 3

We're pretty close to internally nailing down the design decisions on the pre and post deployment scripts as far as what they will contain and how and when they are generated. When we have definitive answers, we'll try to get them out on the forum for your review.

Thanks for the input. Bruce

BruceJohnson at 2007-9-10 >

Visual Studio Team System Hot Topic

Visual Studio Team System New Topic

Visual Studio Team System

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech