我有一个数据库,目前由我申请使用。 我在申请核心时不想改动 任何thing。 但我想对<条码> 信息进行加密,其中<条码>存储或<条码>在数据库中储存。
SQL服务器 2008 (or 2008 R2)应当有一个内部机制,以加密和加密信息,提供并应用这些信息。
如何开展工作? 数据库、数字、绘图、机器人、日期等所有领域都需要加密。
任何帮助
2008年有TDE或数据库总编码。 这对整个数据库进行加密,对数据库的任何用户都透明。 如何做到这一点,详见这两个微软条款:
http://msdn.microsoft.com/en-us/library/cc278098%28v=sql.100%29.aspx
您可以把真实的表格换成国际妇女研究小组和全国发展基金会的启动机构,创建若干用户界定的职能。 你也许需要稍微修改申请。
Instead of that, consider using encryption on file level with schema protection. Such tools like DbDefence available in free edition for small databases and very moderate price for mid-size databases.
如果你真心要按实地对一切进行加密,那么你就会失去指数化的优势,并会带来巨大的业绩恶化。
Free option: place database files on encrypted partition. This however will play no difference for DBA of course. He will be able to select as it would un-encrypted database.
与微软TDE称DbDefence(即与该公司有联系的Im)相似的廉价解决办法。
如你所知,微软将在2016年服务器库中实施新的加密特征,称为“加密途径”。 自2005年版以来,DbDefence一直在为服务器使用这种方法。 这确实有效,你不需要改变申请中的任何内容。
Transparent Data Encryption (TDE)
瞬间数据加密是一种由微软和Oracle开发的技术,用于加密数据库档案。 它提供档案级加密,并通过硬盘和后备媒体的加密数据库保护其他数据。 它不保护过境数据或正在使用的数据。
The encryption will be completely transparent to the applications that access the database. It encrypts the data in the database s data file (.mdf) and log file (.ldf) using Advanced Encryption Standard or Triple DES encryption.
同一钥匙可用于对表格中的所有栏目进行加密,而不论拟加密的表中的栏数。 数据库服务器主干为这些加密钥匙提供加密,储存在数据库的字典表中。
For more info please refer the link How to implement TDE encrytion on SQL Server
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...
