How can we help you today? How can we help you today?

You do not ahve permission for all objects in the database

I am enjoying using SQL PRompt 4 - more than 3.

However. when I switched server + database I get the following message. (It still works fine on the other databases in this server.)

You do not have permission for all objects in the database" '[dbname here]'

SQL Prompt can only maje limited suggestions is you do not have sufficient permissions.

The details show..
Object reference not set to an instance of an object.

System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SqlPrompt.Parser.IdentifierTerminalNode.ResolveCandidate(IDatabaseCandidate& db)
at RedGate.SqlPrompt.Parser.TreeConstructor.FeedToken(IToken`2 nextToken, Int32 skippedTokens)
at RedGate.SqlPrompt.Parser.SqlParser.Parse(String source, Int32 offset, String& filter, IDatabaseCandidate& db)
at RedGate.SqlPrompt.Parser.SqlParser.GetCandidateList(String source, Int32 offset, Boolean caseSensitive)
at RedGate.SqlPrompt.Engine.NewEngine.SqlPrompt4Engine.GetCandidates(Int32 offset)
at RedGate.SqlPrompt.Engine.PromptEngineEmulator.a(Object , CacheEventArgs )
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
at RedGate.SqlPrompt.Engine.NewEngine.SqlPrompt4Engine.a(Object , CacheEventArgs )
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.DoLoadingFinished(IDatabaseCandidate sender, CacheEventArgs args)
at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase.a(IDatabaseCandidate , CacheEventArgs )
at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase.a()

I am sysadmin on all servers so I am at a loss as to what SQL Prompt 4 thinks I cannot access.. ideas?

Thanks
SQL_DBAau
0

Add comment

Please sign in to leave a comment.