minimum rights in SQL Server for SQL complete to work
Posted: 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?
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?