Visit Our UNIX and Linux User Community


Protecting access to partition


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Protecting access to partition
# 1  
Old 07-22-2009
Protecting access to partition

I am trying to setup a computer where only the database can read/write to a partition. Basically, all other entities should fail. One thing I was thinking about was making the database own the partition itself (is this even possible?) but the problem is if someone can masquerade as the database user, this protection is weakened. I was wondering if there is a better way to do this...

EDIT: When I was googling for a solution, I came across a concept called instance-owning database partition. Would someone please explain what that is and if its relevant to my problem?

Thanks
# 2  
Old 07-23-2009
There is no way you can make a database exclusively own a partition. You certainly can reserve the partition for use by the database and it can do raw read and writes to the partition.
# 3  
Old 07-23-2009
Thank You... I'm sorry if its a silly question but what is the difference between owning and reserving a partition?
# 4  
Old 07-23-2009
This is just a confusion of terms I think. I don't think "instance owning database partition" is the same thing at all, it sounds like something happening inside the database, not a partition outside of it; and a database won't be able to do much with a partition, but could store files inside its filesystem if you give it one. Usually, only root has access to the partitions; the filesystems inside them keep their own counsel so to speak.

A partition in OS terms is just a slice of disk space. It acts like a huge file of fixed size. A database wouldn't find this too useful unless you have something extremely specific in mind, nor would most other things, they'd rather create many files of smaller size and directories to order them; so usually a filesystem is created in these partitions.

Once the filesystem is created inside the partition, it can be mounted by the OS, after which it acts just like a directory. It has a user and group like any other directory and can be owned by whatever user you want irrespective of who has raw access to the partition.
# 5  
Old 07-28-2009
What's the motivation behind this? Exclusive access to the partition, so nobody can read the database files or so there can be enough space guaranteed for the database application?
If the former is the reason, I'd suggest using encryption. The latter can achieved through file system quotas, I believe.
Good luck!

Previous Thread | Next Thread
Test Your Knowledge in Computers #424
Difficulty: Medium
C# was designed by Anders Hejlsberg.
True or False?

10 More Discussions You Might Find Interesting

1. Red Hat

Is it possible access software installed on one partition from another

Hello Team my scenario is like i have 2 partitions on server. /apps and /home and i am trying to install my software in /apps partition.intstallation is successful but when i am trying to open something in that its showing blank screen. now if i install that software in /home it works... (2 Replies)
Discussion started by: lalgourav1983
2 Replies

2. Red Hat

Shrink LVM partition & create new Linux Primary partition

Hello All, I have a Red Hat Linux 5.9 Server installed with one hard disk & 2 Partitions created on it as follows, /boot - Linux Partition & another is LVM - One VG & under that 5-6 Logical volumes(var,opt,home etc). Here my requirement is to take out 1GB of space from LVM ( Any logical... (5 Replies)
Discussion started by: gr8_usk
5 Replies

3. Solaris

Partition overlaps another partition while creating new parition in solaris

hi all while formatting hard disk i am getting following error. Partition 1 ends at 266338338 It must be between 34 and 143374704. label error: EFI Labels do not support overlapping partitions Partition 8 overlaps partition 1. Warning: error writing EFI. Label failed. I have formatted the... (2 Replies)
Discussion started by: nikhil kasar
2 Replies

4. OS X (Apple)

How to access a NTFS partition on hard drive through Terminal in OSX ?

Hi , I have a Mac OS X Lion mac book pro. I have a hard drive which I have partitioned in two (a) OSX Partition - Mac OS Extended Journaled format. Mount point: / (b) Data Partition - Windows NT Filesystem format. Mount point: /Volumes/Data I need to access the NTFS partition (I have a... (6 Replies)
Discussion started by: neil.k
6 Replies

5. UNIX for Dummies Questions & Answers

Protecting a folder/directory against root access.

A friend and I run a vbulletin forum which recently got hacked. We believe what wound up happening was the attacker gained access to the VPS box and from there elevated their user accounts to admin status on our forums. Obviously if someone gets into our box in the future it'll be a disaster so... (1 Reply)
Discussion started by: fannypack
1 Replies

6. Linux

Error 24: Attempt to access block outside partition

Grub throwing Error:: Error 24: Attempt to access block outside partition. done the following root (hd0,0) After that when trying to load kernel it is throwing the error. Please guide. new to grub. Thx, Siva. (0 Replies)
Discussion started by: Sivaswami
0 Replies

7. Solaris

How to access a solaris partition

Hi, I have the present scenario on a x86 machine. fdisk c0d0p0 Cylinders Partition Status Type Start End Length % 1 Active Solaris2 1 2500 2500 61 2 ... (14 Replies)
Discussion started by: vibhor_agarwali
14 Replies

8. UNIX for Dummies Questions & Answers

I've created a partition with GNU Parted, how do I mount the partition?

I've created a partition with GNU Parted, how do I mount the partition? The manual information at http://www.gnu.org/software/parted/manual/parted.html is good, but I am sure about how I mount the partition afterwards. Thanks, --Todd (1 Reply)
Discussion started by: jtp51
1 Replies

9. UNIX for Dummies Questions & Answers

Access FreeBSD (BSD) partition from Windows NT/2000/XP

Hello, I have already installed FreeBSD into my hard disk. In one partition I have Windows 2000, and on another FreeBSD. I can access Windows partition from FreeBSD, but is there any way to access FreeBSD partition from Windows? I know how to access Linux (ext/ext2) partition from Win, there is... (9 Replies)
Discussion started by: Aoidas
9 Replies

10. UNIX for Dummies Questions & Answers

understanding logical partition, physical partition

hi, 1) is logical partition the same as physical partition except that one is physical and the other is logical? 2) then it must a one to one ratio? (3 Replies)
Discussion started by: yls177
3 Replies

Featured Tech Videos