Activity overview
Latest activity by ccote
Still cache refresh problem in final release
HI, I logged an inquiry in the beta forum last month telling that SQLPrompt 3 had a problem when connection change occurs. The problem is that the cache is not refreshed properly.
My SQL Server use...
My problem is that when I connect using user A that is the owner of schema A, I need to refresh the cache explicitly by using the cache management.
Why do you need to refresh the cache? Has the schema changed? Is the candidate list empty?
[/quote]
I need to refresh the cache explicitely because the candidate list does not show the tables related to schema A. It shows whatever candidates tables were in the cache. If the cache contained tables from schema B, they would appear in the candidate list. Since I switched connection to user A and the only objects available to him are the one in schema A, I would like the candidate list to show me only schema's A objects. The only way I can achieve it right now (latest 3.0 refresh version) is to manually refresh the cache. Since SQLPROPMPT refreshes the cache when I change the connection, why it doesn't show me the current connection related objects?
Thank you!
Thank / comments
My problem is that when I connect using user A that is the owner of schema A, I need to refresh the cache explicitly by using the cache management.
Why do you need to refresh the cache? Has the...
Schema problem
HI, my db has users thet own schemas. The users have the db_datareader database role assigned to them. I specifically denied view definition for others schemas than the one they are owner. My probl...