Which permissions needed to run?

The simplest way to populate your database with test data.

Which permissions needed to run?

Postby terry_brown » Thu Dec 01, 2011 8:44 am

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,
Tombola Ltd
Posts: 3
Joined: Thu Dec 01, 2011 8:40 am

Postby terry_brown » Fri Dec 02, 2011 9:04 am

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?

Posts: 3
Joined: Thu Dec 01, 2011 8:40 am

Postby terry_brown » Fri Dec 02, 2011 9:05 am

ahh, just received the automated 'this has been raised as a support incident' email - very good support! Looking forward to the answer
Posts: 3
Joined: Thu Dec 01, 2011 8:40 am

Postby james.billings » Fri Dec 02, 2011 1:17 pm

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!
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests