May 2024
Intermediate
425 pages
12h 29m
Chinese
Content preview from CockroachDB权威指南
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
安全保障
|
353
FROM documents d JOIN document_access da
ON(d.security_restriction=da.security_access)
WHERE da.username=current_user;
CREATE VIEW
Time: 482ms total (execution 174ms / network 308ms)
defaultdb> GRANT SELECT ON document_access TO PUBLIC;
GRANT
Time: 306ms total (execution 103ms / network 203ms)
现在，除非我们有
TOP SECRET
权限，否则我们无法看到这些文件：
defaultdb> SELECT description FROM restricted_documents_view;
description
-----------------------------------------
Why CockroachDB is better than Oracle
MongoDB - plans for their destruction
现在，
Ben Darnell
的秘密是安全的了！当然，你需要确保对基本
documents
表的访问的
限制。
除了限制对行的访问外，视图还可以限制对列的访问，方法是在定义中不包含列，或者
在用户没有适当的授权时，使用
CASE
语句来掩盖列的内容。
13.6
日志记录和审计 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.