Questions tagged [database-security]
218 questions
0
votes
1 answer
How to allow a read-only login/user with execute permissions to run stored procedure that drops and creates databases?
I have a SQL Server 2016 instance with a Tools database. The Tools database has a RestoreDBFromPath procedure that can restore a backup file to a database on the server. If the database already exists it drops the database and restores the backup.…

Chris
- 183
- 1
- 9
0
votes
1 answer
Can you move mobile sql database between phones and use it?
Ok lets say that I have an app on my phone that uses a database (SQLLite/ RealmDb etc.) to store data that the app uses, and then some bad entity (hacker) gets hold of my none-rooted-phone and somehow gains access to it.
If the entity can decompile…

Sturla
- 3,446
- 3
- 39
- 56
0
votes
4 answers
How to Prevent windows users to not access SQL server data files
I am working in a product based company and will provide SQL Server 2014 Express edition with our software.
I want your expert comment on security.
Problem: As we are installing a database on client PC then they might be able to see our database…

Vaibhav Shringi
- 1
- 1
0
votes
1 answer
Security concern for connecting to a remote database
I'm migrating a small Aspnet MVC website from Godaddy shared hosting to AWS. I already have an EC2 configured and a duplicate website is already running on a IP. I will next migrate the domain to Route53. The problem is the database is still on…

Laurence
- 7,633
- 21
- 78
- 129
0
votes
1 answer
How to secure database credentials in spring mvc service layer
I have to create a banking application using Spring MVC and MySQL enterprise database. Encryption and Decryption of data are done using keys provided by MySQL Enterprise database. Some of the options that I have found to secure this database…

Chinta Sai Vamshi
- 319
- 3
- 11
0
votes
0 answers
Secure my SQL SERVER database
My database is visible to all users in my work environment and it's a bit risky. I need to make this database visible to just a special user who can execute queries.
I'm not a database specialist

fatiDev
- 5,752
- 7
- 28
- 45
0
votes
2 answers
Is it safe to store a hashed password in the same database with the rest of the data
I wanted to kow if it is save to store my hashed password inside a table, that resides next to the rest of my other data(tables) in the same database?
For example imagine the following (simplified) structure (with a lot of other…

Maximilian Lindsey
- 809
- 4
- 18
- 35
0
votes
0 answers
Does an SQLite database offer additional security in comparison with Files in Android?
I am making an Android application and need to decide what type of data storage method to use. The size of the data I need to store is fairly small and therefore I was thinking of storing my data in a JSON format and saving it to a file…

sums22
- 1,793
- 3
- 13
- 25
0
votes
2 answers
How do i create sql server database that can only be opened by application itself?
I am developing a desktop app in c# using "entity framework database first approach" that is required to be highly secured i.e. no one can access its database without login into that application and no one can extract the data directly using…

Luser
- 31
- 3
0
votes
3 answers
SQL Server Mgt Studio not showing table?
I have a table in SQL Server 2000 Standard Edition called "dbo.T668" (don't blame me for the naming convention).
I'm working on the server using SQL Server Management Studio 2005, and for some strange reason, I can't see the table at all in the list…

Sam Schutte
- 6,666
- 6
- 44
- 54
0
votes
1 answer
SQL dual database security
So this has less to do with code itself and more about efficiency and practicality.
At my previous job, we had multiple databases. One that was accessible through public means, and one that can only be accessed privately. The public database could…

QConscious
- 87
- 1
- 1
- 11
0
votes
0 answers
How to encrypt and decrypt a particular filed in a Database
I have a simple question for you and I would like to know if there are some best practices.
I have a mysql table that has a field that points to a filesystem (a link to an image).
I would like to encrypt this item and, when it will be the time, I…

Paride Letizia
- 330
- 1
- 4
- 23
0
votes
1 answer
Using a REST API that interfaces with AWS RDS (psql) - how do I protect the db access (writes) beyond API authentication?
I am quite new to backend type work, so I am teaching myself postgres and express. I have built an API that uses JWT authentication and allows calls only from one host, but I am wondering if there is anything more I need to do in order to protect…

a person
- 1,518
- 3
- 17
- 26
0
votes
1 answer
How do you protect against malicious code in web forms?
I understand this is probably going to sound like an extremely rudimentary question to some of the more senior people on here but, I had to ask. I understand Google is there for my use but, I wanted to make sure I found the right answer. My friend…

FrancisF
- 1
0
votes
2 answers
Forgot my password for secure database
I created a database structure in which a user gets a public and a private key to access information, the public key is uploaded to the database and the private key is encrypted with the users password so I let he can access it. To implement a…

Mercury
- 594
- 1
- 12
- 28