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

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 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. Howver, when I change connection, I can see that SQLPROMPT is refreshing the cache. My question is why do I need to refresh the cache when I change form connection to another?

Thank you,
Ccote
ccote
0

Comments

2 comments

Sort by
  • Tilman
    Hi,

    Thanks for posting. I'm afraid I can't reproduce your problem. Or maybe I don't quite understand what you are after.
    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?
    Howver, when I change connection, I can see that SQLPROMPT is refreshing the cache. My question is why do I need to refresh the cache when I change form connection to another?
    One reason is, that if the new user doesn't have access to the database we don't want to display the objects. Is this causing a problem for you?

    Regards,

    Tilman
    Tilman
    0
  • ccote
    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
    ccote
    0

Add comment

Please sign in to leave a comment.