Which permissions needed to run?
terry_brown
Posts: 5 Bronze 1
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
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
Comments
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
Anyway, in answer to your query, it's cropped up before and the article relating to SQL Compare Permissions helped - see here
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!
Redgate Software