• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 699
  • Last Modified:

Interbase security

How can i restrict other peoples from opening my gdb (database file).

Can i give password or something else.

Plese help asap

Rajni
0
rajniyadav
Asked:
rajniyadav
4 Solutions
 
YodaMageCommented:
It all depends on what you are trying to do. If all you are trying to do is restrict access, then that is what Users are for, and I'm not sure what you need.
0
 
thegroupCommented:
Only the SYSDBA or the Owner of the database objects (tables, views, procedures.) can change the definition of the objects.

Interbase 6.5 can grant DDL privileges to another users and have access validation against database modifications.

Could you post more info on your problem ?
0
 
rajniyadavAuthor Commented:
Right now when i create a gdb file with sysdba user then i can copy that machine on some other machine and i can open that file in interbase to see the data, modify\ delete the data or i can even delete the table also.

I want to restrict that. I don;t want anybody to be able to open gdb file that i have created.

Is that possible?


Rajni
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
YodaMageCommented:
Create database with user other than sysdba.
0
 
rajniyadavAuthor Commented:
YodaMage

i have already create a database i have setup local server with sysdba and created a database.

when creating a database it doesnot ask for any user name or password


how can i do that

Rajni

0
 
YodaMageCommented:
What does your isc4.gdb look like?
0
 
YodaMageCommented:
There is no security like you are looking for.

Read here for one of the better posts about security and IB:

http://www.mers.com/cgi-bin/mer.exe/EXECSEARCH?pageno=1&searchtext=dalton+calford+security+table&grouptext=mers+interbase&linktype=viewmsg&msgno=47580&boardno=240
0
 
ITugayCommented:
YodaMage,

thank you for interesting article. It's very old of date, but seems the problems are the same :(

I'm using another way to protect my databases. What we are trying? Prevent another unatorized people to extract data from database. If data accessed from application you built then provide some mechanism to encode data before put there and decode data after get. Not all data, but only important tables or fields. There a lot of way to do that. (I'm using primary key value to encrypt record content.) Much easy to protect application then a database, so I choosed easy way.

----
Igor


0
 
rajniyadavAuthor Commented:
Right no body can view my data or delete my tables.
but they can view the meta data?

i want to restrict other user from viewing my meta data also. How can i do that?


pls answer As soon as possible
Rajni



0
 
grolschisgoodCommented:
you should restrict peoples access to the gdb file by applying windows NTFS permissions.  As long as your windows SYSTEM user has rights to the database this will allow interbase to serve the file as a database. then access to the database on you server is managed through the interbase users.

By stopping people having read or write access to the GDB file itself, they will not be able to copy the gdb file from your server onto their own server and therefore access it using their sysdba user.

this implies that you are running winnt, 2000, or xp pro and your drive is formatted as NTFS

k cam
0
 
kacorretiredCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
       to split points as follows:
                                                125 points for grolschisgood
                                                125 points for thegroup
                                                125 points for YodaMage
                                                125 points for ITugay
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

kacor
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now