Red Gate forums :: View topic - Which permissions needed to run?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Which permissions needed to run?

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
terry_brown



Joined: 01 Dec 2011
Posts: 3

PostPosted: Thu Dec 01, 2011 9:44 am    Post subject: Which permissions needed to run? Reply with quote

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 Smile Which perms do I absolutely need to run data generator?

Many thanks,
Terry
Tombola Ltd
Back to top
View user's profile Send private message
terry_brown



Joined: 01 Dec 2011
Posts: 3

PostPosted: Fri Dec 02, 2011 10:04 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
terry_brown



Joined: 01 Dec 2011
Posts: 3

PostPosted: Fri Dec 02, 2011 10:05 am    Post subject: Reply with quote

ahh, just received the automated 'this has been raised as a support incident' email - very good support! Looking forward to the answer
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1117
Location: My desk.

PostPosted: Fri Dec 02, 2011 2:17 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group