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

Postby terry_brown » Fri Dec 02, 2011 10: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?

Thanks,
Terry
terry_brown
 
Posts: 3
Joined: Thu Dec 01, 2011 9:40 am

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

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

Postby james.billings » Fri Dec 02, 2011 2: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!
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 1 guest