While creating new project getting "Reading Permissions" err

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

While creating new project getting "Reading Permissions" err

Postby rockinder » Mon Sep 27, 2010 6:42 pm

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
rockinder
 
Posts: 4
Joined: Mon Aug 31, 2009 8:12 pm

Post subject: While creating new project getting "Reading Pe

Postby rockinder » Mon Sep 27, 2010 6:57 pm

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
rockinder
 
Posts: 4
Joined: Mon Aug 31, 2009 8:12 pm

Postby Anu Deshpande » Wed Sep 29, 2010 11:17 am

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

SQL Data Generator 1

Postby rockinder » Fri Oct 01, 2010 2:18 am

Thanks Anu your suggestion for SQL 2008 worked
rockinder
 
Posts: 4
Joined: Mon Aug 31, 2009 8:12 pm

Postby Anu Deshpande » Fri Oct 01, 2010 11:19 am

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests