473,480 Members | 4,852 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

how to encrypt the complete table

1 New Member
how to encrypt the complete table in oracle/Sql server database.So that there is no way for hackers to hack my data.
Sep 4 '11 #1
1 2089
rski
700 Recognized Expert Contributor
I'm not sure what kind of encryption do you mean.

1) You can use TDE to encrypt data on the disk. When you read the encrypted table oracle will decrypt data in-flight. THis is OS level encryption. You will nedd Oracle Wallet to use it.
2) You can use dbms_crypto package to encrypt data in the tables but it will be time-consuming the read the table because decyption should be done (you will have to take care of encryption/decryption process).

Before you encrypt something make sure that strong enough password is not enough for you. Remove also oracle standard accounts you don't need and set proper permissions.
Sep 5 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1360
by: Aris | last post by:
hello: i am new in mysql .. i would like make password to access one table i dont need the privillage method . if there is not .please tell me how can i encrypt/decrypt table . excuse my...
2
1430
by: tdmailbox | last post by:
I have a database with three tables tbl_listings - listings of houses on for sale tbl_intersted - table which tracks if a user is interested in the listing, it has two columns mls(the key for...
14
2348
by: uli2003wien | last post by:
Dear group, we are running a SQL-Server Database which is about 30 GB large. The purpose of this database is to contain periodic data from automatic devices which insert values into some tables....
10
9570
by: Javier Gomez | last post by:
I have a table with 15.000 records. How can encrypt all information if after will shown in a form (text box)decryted ????? Thanks in advance Javier Gomez
3
1605
by: astro | last post by:
I have a datagrid that is two levels down from the dataview (i.e. grandchild). I have spent 3 hours trying to get the syntax of determining it's real datasource (i.e. not it's source based on it's...
1
3888
by: JackM | last post by:
I'm not sure if this qualifies as a mysql or a php question so I'm asking in both groups. I am pulling the results of a mysql query from my database and want to print the results into a two...
4
1283
by: mortb | last post by:
Hi! I have a really large and complex table. The table may consist of several thousand rows. When I render the table with asp.net web controls the control won't stream out to the browser before...
3
31553
by: visu | last post by:
Hi , can anyone tell me how to get the complete table schema including constraints, primary key ..etc. through sql Query in Ms access. We can get table information in MS SQL Server by means...
1
1299
by: Simon | last post by:
Dear reader, I made a table and now I do not know in which mdb the table is stored. Is there any help to search for a table in several mdb's even if you do not know the complete table name...
3
7017
Soniad
by: Soniad | last post by:
Hello, I want a complete table structure assign to a variable and then insert this table structure in one of column of sql table. the problem i am facing is vbscript is not interpreting html...
0
6905
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7041
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7080
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6736
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
6908
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5331
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4478
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2994
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1299
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.