April 8, 2017 at 12:50 am
Hi
To active Intellisence I have to use sysAdmin Role. Which permission required to assign to other roles.
Thanks.
April 8, 2017 at 8:55 am
Does it depend on the Role?
Go to Tools->Options and under Transact-SQL chose IntelliSense. Check if it's enabled and the other settings.
In an opened "New query" hit CTRL+Shift+R or
Edit->IntelliSense->Refresh local cache to refresh it.
Igor Micev,My blog: www.igormicev.com
April 8, 2017 at 9:45 am
I would say it may require one of the following
sysadmin - but should not be granted
dbowner - should be avoided
view definition (database level) or view any definition (server level)
for objects created by the individual no other permissions should be required.
May be wrong - never really looked into that as I always have at least view definition at a database level, most times at server level on the servers where I am not a sysadmin.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply