?
Solved

Interbase security

Posted on 2002-07-02
12
Medium Priority
?
693 Views
Last Modified: 2013-12-09
How can i restrict other peoples from opening my gdb (database file).

Can i give password or something else.

Plese help asap

Rajni
0
Comment
Question by:rajniyadav
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
12 Comments
 
LVL 4

Expert Comment

by:YodaMage
ID: 7127116
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
 
LVL 1

Assisted Solution

by:thegroup
thegroup earned 500 total points
ID: 7129747
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
 

Author Comment

by:rajniyadav
ID: 7137753
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Expert Comment

by:YodaMage
ID: 7140489
Create database with user other than sysdba.
0
 

Author Comment

by:rajniyadav
ID: 7143001
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
 
LVL 4

Accepted Solution

by:
YodaMage earned 500 total points
ID: 7144172
What does your isc4.gdb look like?
0
 
LVL 4

Expert Comment

by:YodaMage
ID: 7144187
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
 
LVL 9

Assisted Solution

by:ITugay
ITugay earned 500 total points
ID: 7501877
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
 

Author Comment

by:rajniyadav
ID: 7818987
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
 
LVL 1

Assisted Solution

by:grolschisgood
grolschisgood earned 500 total points
ID: 8221561
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
 
LVL 10

Expert Comment

by:kacor
ID: 9824551
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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question