minimum rights in SQL Server for SQL complete to work

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
redhat
Posts: 4
Joined: Thu 07 Nov 2013 20:04

minimum rights in SQL Server for SQL complete to work

Post by redhat » Thu 07 Nov 2013 20:25

I am a licensed user. I loaded SQLcomplete as an OS admin on my workstation. SQL complete works fine as long as I am a database admin on the SQL server.

If I am a restricted user (anything less that serveradmin on SQL server) SQL complete does not work. For example select * from dbname.. hit ctrl-space does not show me the tables (I do get a drop down of functions, not tables).
If I am a serveradmin, the dropdown includes tables.

I don't want to program as serveradmin-- what would the minimum rights be?

alexa

Re: minimum rights in SQL Server for SQL complete to work

Post by alexa » Fri 08 Nov 2013 10:08

Could you please provide us the scripts to create a test database and the rights of the user for the connection?

Post Reply