?
Solved

Security in paradox tables

Posted on 2001-06-13
7
Medium Priority
?
286 Views
Last Modified: 2010-04-06
Hi,
I have written a desktop App with paradox tables.Know i want to perform login operation in the Application, which Admins of App can define users/groups and also define permissions for them. at this time i have done all of them
, but these users/groups informations are storded in paradox tables and to perventing users and admins to access the row data, directly from tables, i defines a master password for them and actually you know that paradox password is not reliable.
Now i want to know is there any better solution or standard way to store users/groups data.
what do you do as an expert, when you want to store users/groups informations so nobody can access them directly, just from your interface?
0
Comment
Question by:Mohamadi
[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
7 Comments
 

Expert Comment

by:mpzlarge40
ID: 6189219
hi
you must
1.open your table in database desktop
2.select "restructure" from "Table" menu
3.select "password security" from "table property" in restructire window
4.select a master password for table and save table
5.in your program befor open table write under line:
session.addpassword('your password');
6.open table

goodluck
MPZ
0
 

Author Comment

by:Mohamadi
ID: 6189250
I know all about defineing a password in paradox, but i siad that the password in paradox is not reliabel.
i mean that thers is two master key whick could open a protected paradox table without konwing tha real password.
i want to know about any other way to store users/groups data.
0
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6189612
Hello

  you said paradox password is not reliable, and that's right, but if you want to create users with different permissions, you can build a table and define all the users in it and specified for each user his/her permission to access to the tables(read, write, insert, delele,...) also you can set a user name and password in this table to use ur own security not paradox security

Mohammed
0
Technology Partners: 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 27

Expert Comment

by:kretzschmar
ID: 6190174
mohamedi is right,

there are two masterpasswords in paradox,
which allow access to any password protected table.

an idea would be to encrypt the data additional with a crypting tool

meikl
0
 

Author Comment

by:Mohamadi
ID: 6193002
I had placed users/groups data and all permissions in paradox tables, so far so good, but in order to protect the data from being accessed directly (i mean may be some user going to open the tables directly by means of database desktop), i should add master password for tables.
so we get back to first step, [paradox password is not reliable], i mean that thoses users can open my tables even thay do know the password and can see all of users name, password, can change permissions and lots of things that they do not have permissions for that.
what should we do to overcome this problem, may be we should try some other tools to store users/group data or
as kretzschmar siad, the data with encrypt tools?
any idea?

thanks

nima,
0
 
LVL 22

Accepted Solution

by:
Mohammed Nasman earned 260 total points
ID: 6193091
Hello
 
look at the Paradox Process Password Protection, may it helps you

http://www.rksolution.cz/DELPHI/DELPHI.htm#00009

Mohammed
0
 

Author Comment

by:Mohamadi
ID: 6200418
Thanks mnasman,

Nima
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month11 days, 4 hours left to enroll

770 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