Red Gate forums :: View topic - While creating new project getting "Reading Permissions" err
Return to www.red-gate.com RSS Feed Available

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

While creating new project getting "Reading Permissions" err

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rockinder



Joined: 31 Aug 2009
Posts: 4

PostPosted: Mon Sep 27, 2010 6:42 pm    Post subject: While creating new project getting "Reading Permissions" err Reply with quote

When trying to create a new project or trying to open a project the user gets "Create Project - Reading Permission". this happens right at the end when tables etc have been read on the database I'm trying to connect. what permissions do I need to have extra.

the DB is on a server where the user has access to few of the 30+ db. the user is flagged as Owner/ Public to this DB
Back to top
View user's profile Send private message
rockinder



Joined: 31 Aug 2009
Posts: 4

PostPosted: Mon Sep 27, 2010 6:57 pm    Post subject: Post subject: While creating new project getting "Reading Pe Reply with quote

further information, this ahppens when the data generator is at the "REading Permissions" part. before this everything else works ok like reading SP, Columns, Indexes, etc
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Wed Sep 29, 2010 11:17 am    Post subject: Reply with quote

Many thanks for your post and apologies for inconvenience caused.

For SQL Server 7 or SQL Server 2000, SQL Prompt requires administrative or dbo or Sys Admin permissions.
For SQL Server 2005 you can use the same permissions as for SQL Server 7/2000 or alternatively you can use the GRANT VIEW DEFINITION TO [{username}] which provides SQL Prompt with permission to retrieve the metadata without giving dbo access.

For SQL Server 2008, it may be necessary to grant VIEW SERVER STATE to access information about encryption keys otherwise a 'User does not have permission to perform this action' message may prevent the display of candidates.

Kindly let me know after granting the respective rights your issue is resolved or not.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
rockinder



Joined: 31 Aug 2009
Posts: 4

PostPosted: Fri Oct 01, 2010 2:18 am    Post subject: SQL Data Generator 1 Reply with quote

Thanks Anu your suggestion for SQL 2008 worked
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Fri Oct 01, 2010 11:19 am    Post subject: Reply with quote

Many thanks for the confirmation.

We are pleased that your issue is resolved.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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