Office中国论坛/Access中国论坛

标题: 如何查看加密的视图 [打印本页]

作者: janny 时间: 2003-10-4 01:03
标题: 如何查看加密的视图
我在设计视图的过程中，使用WITH ENCRYPTION对视图进行加密。可之后要更改该视图的定义时，却无法查看原视图的内容，请问应该怎样来查看原视图的定义。

[em03]

作者: janny 时间: 2003-10-5 04:56
为什么没有人回答？是能还是不能？

作者: 阿罗 时间: 2003-10-10 04:48
老兄你好过分。自己研究BOL不可以啊，上网找资料不可以啊？

The definition of a sensitive view can be encrypted to ensure that its definition cannot be obtained by anyone, including the owner of the view, by using the WITH ENCRYPTION option when the view is created.

--Creating an Encrypted View
CREATE VIEW vwEncrypted
WITH ENCRYPTION
AS
SELECT CompanyName AS C, ContactName AS CN
FROM Customers AS CL

Once the view is created, its definition will be unreadable。 Therefore, make sure that you save your view definition in a script file in case you ever need to modify it

作者: 唐小小 时间: 2003-10-10 16:18
臭阿罗

作者: 阿罗 时间: 2003-10-10 21:42

以下是引用唐小小在2003-10-10 8:18:22的发言：
臭阿罗

[em03]

作者: 阿罗 时间: 2003-10-10 21:42
[em03][em03][em03][em03][em03][em03]

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)