物理数据存储从表及其视图获取
美好的一天！
谁知道 SQL Server 在物理上是如何工作的：
我有受保护的表，没有人可以直接从它的视图中提供信息。但重要的是要知道，我通过视图获得的数据存储在任何地方？我想说，我通过视图获取数据，读取它，关闭查询窗口，任何人都可以找到这些数据（也许它们存储在 RAM、池或 HDD 中……任何地方？
也许如果服务器崩溃/中止，之后重新启动，有人可以找到服务器崩溃之前查看的数据吗？
添加！
我从服务器选择数据。当数据被选择时，它们发送到客户端，服务器从内存中删除临时数据，并且不在服务器上存储任何数据。我认为这是真的。
如果我从服务器选择数据，在选择过程中服务器会出现异常。服务器不会删除临时数据。任何人都可以从任何地方获取这些临时数据并使用吗？
Good day!
Who knows how physically SQL Server works the question:
I have protected table and nobody can give information from it directly, just with its view. But it is important to know, the data, which I get with view, is stored anywhere? I wanted to say, that I get data with view, read it, closed query window, can anybody find these data (maybe they are stored in RAM, pool, or HDD … anywhere?
Maybe if server crashes/abort, after restart, can anybody find data, which a got with view before server’s crash?
Addition!
I select data from server. When data are selected, they send to the client and server delete temp data from smemory and don't store anywere at the server. I think it is true.
If I select data from server, in selection process server rise exception. Server doesn't delete temp data. Can anybody get these temp data from anywhere and use?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
但是，为了简单起见，有 2 个安全方面：逻辑/应用程序和物理/基础设施
。查看控制逻辑/应用程序安全性。您似乎已经正确完成了此操作。
物理/基础设施安全涉及服务器访问、远程桌面访问、系统管理员访问或物理介质（SAN、磁带）访问。简单来说，这就是服务器机房上锁的原因。
However, for simplicity, there are 2 security aspects: logical/application and physical/infrastructure
The view control logical/application security. You appear to have done this correctly.
Physical/infrastructure security relates to server access, remote desktop access, sysadmin access, or access to physical media (SAN, tapes). This is why server rooms have locks on them in simple terms.