TAILIEUCHUNG - Introduction to Database Systems- P12

Tham khảo tài liệu 'introduction to database systems- p12', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Please purchase PDF Split-Merge on to remove this watermark. 524 Part V Further Topics Corresponding GRANT - GRANT SELECT ON SSQ TO Fidel Example 5 from Section involved a context-dependent authority. SQL supports a variety of niladic built-in operators CURRENT-USER CURRENT-DATE CURRENT. TIME and so on that can be used among other things to define-context-dependent views however it does not support an analog of the DAY operator we used in our original -------- -------------------- Corresponding GRANT GRANT SELECT UPDATE STATUS ON S NINE TO FIVE TO ACCOUNTING Note however that S_NINE_TO FIVE is rather an odd kind of view its value changes over time even if the underlying data does not. What is the corresponding predicate Furthermore a view whose definition involves the built-in operator CURRENT. USER might even in fact probably will have different values for different users. Such views are really different in kind from views as normally understood in effect they are parameterized. It might be preferable at least conceptually to allow users to define their own potentially parameterized relation-valued Junctions and then treat views like S_NINE_TO_FIVE as just special cases of such functions. Be that as it may the foregoing examples illustrate the point that the view mechanism provides an important measure of security for free for free because the mechanism is included in the system for other purposes anyway . What is more many authorization checks even value-dependent ones can be done at compile time instead of run time a significant performance benefit However the view-based approach to security does suffer from some slight awkwardness on occasion in particular if some user needs different 3. CREATE VIEW SSPPO AS SELECT FROM S WHERE EXISTS SELECT FROM SP WHERE EXISTS SELECT FROM P . - WHERE - AND - AND - Oslo Corresponding GRANT GRANT SELECT

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.