Which permissions needed to run?

[terry_brown]

hey guys,

My user account is in db_owner for the DB I want to create data for, and I have no problem using our SQL Compare and SQL data compare against the same DB, but when I run Data Generator it says:

"Create Project
- Reading permissions

The user does not have permission to perform this action"


I'm definitely using the same account as I do with Compare/DCompare - is db_owner not enough for SQL Data Generator?

If so, what specific roles do I need to perform this task?

I've attempted on local instance databases (where I have pretty much everything that sa has) and that works a treat, though our infrastructure team will be very reluctant to grant that level of access to a developer (and to be honest, the power would go to my head! lol)


Help Which perms do I absolutely need to run data generator?

Many thanks,
Terry
Tombola Ltd

[terry_brown]

do I need to clarify what I mean or raise it via a support ticket?

I guess redgate staff view these forums looking at the other forum posts - surely someone can tell me what permissions I need to run red gate data generator?

Thanks,
Terry

[terry_brown]

ahh, just received the automated 'this has been raised as a support incident' email - very good support! Looking forward to the answer

[james.billings]

Hi, thanks for posting. We do respond to unanswered forum posts- they get auto-logged as tickets after a day or two. The idea of the forums is more for "inter-user-discussion", and if you have an urgent enquiry it's usually best to email support@red-gate.com directly so you get a faster response.

Anyway, in answer to your query, it's cropped up before and the article relating to SQL Compare Permissions helped - see [url=http://www.red-gate.com/supportcenter/Content?p=SQL%20Compare&c=SQL_Compare/knowledgebase/SC_Permissions_Required.htm]here[url]

The bit that may be causing it is if you're on SQL 2008; you may need the "View Server State" permission as described in that article. This is so that our tools can work with encrypted objects in your database.

Hope that helps!