Security and Cryptography
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsSystem AdministrationSecurity and Cryptography

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old August 29th, 2011, 03:36 PM
djack109 djack109 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2011
Posts: 2 djack109 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 3 m 10 sec
Reputation Power: 0
What if I just copy the FDB file ?

I'm new to firebird so please for give this question if it sounds stupid. And immediate apologies if this message is in the wrong topic

I've been all over Google and several firebird forums and can't really find an answer.

I've been working with a firebird database for a a little while now and to help work in two places say at home I just took a copy of the fdb file, installed IB Expert and Firebird Server on my PC and away I went

My question is, what's to stop anyone just copying the fdb file, from what I can see the server controls security and if you hook up the fdb file to your own firebird server with the your own sysdba account then you have total freedom to the database, even if you change the sysdba password

Is anyone able to clarify or explain how Firebird security works. I'm working on a website and using firebird for the database and this is a concern for me.

Thanks loads

Reply With Quote
  #2  
Old August 30th, 2011, 04:18 PM
OmegaZero OmegaZero is offline
Contributing User
Dev Shed Novice (500 - 999 posts)
 
Join Date: May 2007
Posts: 737 OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level)OmegaZero User rank is General (90000 - 100000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 22 h 50 m 32 sec
Reputation Power: 928
I've never worked with firebird myself, but typically the password stored in the database is used by the daemon process to authenticate connections to the database. To protect the database files themselves you,
(A) Don't permit access to the server from the internet, only from the CGI server/application server/etc. that uses the database.
(B) Create a separate user account just for the database and set file permissions so that only the database daemon has read/write privileges to the database files.
(C) Don't put the database files where an FTP/HTTP/etc server has access to them.
Or preferably, all the above.

And it's never a bad idea to avoid storing sensitive information in a database that can be accessed over the internet.
__________________
sub{*{$::{$_}}{CODE}==$_[0]&& print for(%:: )}->(\&Meh);

Reply With Quote
  #3  
Old September 2nd, 2011, 09:05 AM
djack109 djack109 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2011
Posts: 2 djack109 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 3 m 10 sec
Reputation Power: 0
Thanks for the info. I've done all that as a matter of course anyway but my query was on top of that. I was just curious

I never store sensitive information in any of my on-line applications I don't want to go the the expense of security the server to satisfy all the relevant data standards

passwords are generated manually off line and hashed on the server.

i don't even store email addresses on-line

i keep an offline copy of the database with all that info in and sync regularly with the on-line copy and generate emails on a seperate machine

Reply With Quote
Reply

Viewing: Dev Shed ForumsSystem AdministrationSecurity and Cryptography > What if I just copy the FDB file ?

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap