HeidiSQL crashes for autocomplete for MSSQL with restricted privileges.

[expired user #10713]'s profile image [expired user #10713] posted 7 years ago in General Permalink

When user has restricted privileges and connect to sql server database from heidiSQL, autocomplete for table names, columns, doesn't work at all and crashes the program. It's because of restricted privileges, this command failed

EXEC sp_helptext 'dbo.DemandsFullText';EXEC sp_helptext 'dbo.DemandsIdFullText';EXEC sp_helptext 'dbo.fn_diagramobjects';EXEC sp_helptext 'dbo.sp_alterdiagram';EXEC sp_helptext 'dbo.sp_creatediagram';EXEC sp_helptext 'dbo.sp_dropdiagram';EXEC sp_helptext 'dbo.sp_helpdiagramdefinition';EXEC sp_helptext 'dbo.sp_helpdiagrams';EXEC sp_helptext 'dbo.sp_renamediagram'; / SQL Error (15197): There is no text for object 'dbo.DemandsFullText'. /

Possible solution: Object, which cannot be discovered - discovery query fails - won't be in the autocompletion and on the other places.

It's common situation, when user has some restriction only for some tables, views etc. For such users heidiSQL isn't mostly usable nowadays.

Please login to leave a reply, or register at first.