Make user search by primary key code

Question

1.00/5 (1 vote)

See more:

i want to know if user know and treate with primary key in table is this true? in my case each management has (a unique code, Not changing)  and user should know it and search in system by it is there any problem if i set this code as a primary key related with security or any other problem

What I have tried:

i make a lot of search and not found any one mention to if there is security problem or not

Posted 21-Aug-21 21:22pm

reemh

Updated 21-Aug-21 22:39pm

Add a Solution

Comments

Richard MacCutchan 22-Aug-21 3:37am

The user should not need to know anything about the database. The UI should present options and accepts requests in native language. What happens behind the scenes is something they have no control over.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2021-08-21T22:39:00

I prefer to use multiple keys. The primary key is always a surrogate (or synthetic) key which guarantees uniqueness bot holds no other meaning. This also means that no-one needs to know the value of the surrogate key except the system.

The other keys are natural (or business) keys. These are based on the values entered by the user and they can be used for searching the data. Natural keys enforce uniqueness on a logical level. For example same email cannot be entered twice etc.

To learn more about these concepts, have a look at
- Surrogate key - Wikipedia[^]
- Natural key - Wikipedia[^]