Grant sql assistant

Question

Post reply

Grant sql assistant

kakovatos7

SSC-Addicted

Points: 428
More actions
September 10, 2018 at 2:30 am

#367959

Hello to all,
I have one user as full granted and another one as a read-only user to SQL server.
The first user can work correctly with the default sql assistant, but the second user isn't capable to use sql assistant.
Is there a permission issue, and if so, how can it be fixed?
Thank you.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 1

Steve Jones - SSC Editor

SSC Guru

Points: 736642

September 10, 2018 at 7:26 am

#2005054

What's the sql assistant?

kakovatos7 SSC-Addicted Points: 428 More actions · Answer 2

The embedded assistant in SQL, since version 2012 and above.

Phil Parkin SSC Guru Points: 246993 More actions · Answer 3

kakovatos7 - Monday, September 10, 2018 8:03 AM
The embedded assistant in SQL, since version 2012 and above.

I don't know what this is either. Can you identify the exact menu options you are referring to?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Sue_H SSC Guru Points: 90860 More actions · Answer 4

kakovatos7 - Monday, September 10, 2018 8:03 AM
The embedded assistant in SQL, since version 2012 and above.

It''s a third party product, not a Microsoft product. What are the errors and what is the user trying to do?

Sue

kakovatos7 SSC-Addicted Points: 428 More actions · Answer 5

I don't mean the third party product, I am talking about the embedded intelligence to SQL.

andreas.kreuzberg SSCertifiable Points: 6193 More actions · Answer 6

Hm,
I am confused. Do you mean this function in the SSMS:
IntelliSence enabled ?
I didn't hear something like "embedded intelligence" with a SQL Server.
Have you got a link or screenshot or something like this?
Best regards,
Andreas

kakovatos7 SSC-Addicted Points: 428 More actions · Answer 7

Yes, it's the IntelliSense assistant.
It seems that it's working with a user that owes full access to the SQL server, but not with a user that has read-only access.
I suppose it has to do with something else and occasional, but I am just asking if someone knows in case it has to do with the type of permission the user has to the server.

andreas.kreuzberg SSCertifiable Points: 6193 More actions · Answer 8

Hi,
here are some usefull tips:
https://www.sqlservercentral.com/Forums/1614520/Intellisense-on-some-databases-not-others?PageIndex=2
Have you got an unused linked server?
Or do you use different version of SSMS?
Kind regards,
Andreas

kakovatos7 SSC-Addicted Points: 428 More actions · Answer 9

Thanks a lot, I 'll try the solutions and come back.

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 10

I don't know what permissions are needed, but the docs seem to indicate this works on your connection to SQL Server. I'm guessing the OE connection, but not sure.

https://docs.microsoft.com/en-us/sql/relational-databases/scripting/intellisense-sql-server-management-studio?view=sql-server-2017

If you have other questions or issues, please refer to this as intellisense. It's not a SQL assistant or SQL intelligence.

Sue_H SSC Guru Points: 90860 More actions · Answer 11

kakovatos7 - Tuesday, September 11, 2018 12:16 AM
I don't mean the third party product, I am talking about the embedded intelligence to SQL.

My apologies. I had no idea that SQL Assistant meant Intellisense in SQL Server Management Studio. Try the troubleshooting documentation:
Troubleshooting IntelliSense

Sue