How can we help you today? How can we help you today?

SQL Prompt V3 - Access to Database Schemas

Hi

If sql prompt 3 tries to retrieve the databse schema and I don't have full access, it does not work. Do I need full access to the database?V2 did not do this. It still retrived the schema although I did not have full access. How can I bypass this. Even if I put in our development database server, it still tries to connect to our prod server.

Thanks
ait
0

Comments

1 comment

  • Bart Read
    Hi there,


    Due to time constraints we were forced to use a meta-data model that is used in several of our other products and which pulls back all meta-data for the given database, and therefore requires dbo level permissions (db_datareader is insufficient). It appears to fail at the point of loading check conditions, however the problem is really with column data types. We are looking in to fixing this in the near future to allow the meta-data model to work with partial data, however this is not an inconsiderable body of work and due to potential knock-on effects will require significant testing so we are unlikely to have this ready for the final release in January, but rather in a later patch release.

    I hope that helps.


    Many thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.