Database Security

Categories: Code Problem / Data Structures and Algorithms / Recursion (32) Code Problem / Data Structures and Algorithms / Binary Search (30) Code Problem / Data Structures and Algorithms / Linked Lists (26) Code Problem / Data Structures and Algorithms / Backtracking (26) Code Problem / Data Structures and Algorithms / Stacks and Queues (25) Code Problem / Data Structures and Algorithms / Hashing (24) Databases / SQL / Backup and Recovery (19) Code Problem / Data Structures and Algorithms / Arrays and Strings (19) Databases / SQL / Database Normalization (18) Code Problem / Data Structures and Algorithms / Time Complexity (17) Databases / SQL / Locking (16) Databases / SQL / Replication (15) Databases / SQL / SQL Queries (13) Code Problem / Data Structures and Algorithms / Graphs (13) Databases / SQL / Database Security (13)  More...

Recent solutions:

Check these solutions from our community:
Databases / SQL DifficultyHard SQL
Write a SQL query to find all users with the role of 'admin' or 'manager'.
About this solution: The solution above is optimal because it uses the WHERE clause to filter the results.
Nov 25
Databases / SQL DifficultyHard SQL
This technical problem involves writing a SQL query that returns the salt for a given user's password. The example input and output are provided in the body of the problem.
About this solution: The candidate's solution is correct and efficient.
Nov 24
Databases / SQL DifficultyHard SQL
This technical problem deals with writing a function that can take in a database name and table name, and return the number of rows in the table.
About this solution: The candidate's solution is complete and solves the problem. The candidate's approach is to use the COUNT() function, which is an optimal way to count the number of rows in a table.
Nov 22
Databases / SQL DifficultyHard SQL
The goal is to find the number of unique users in a table. The table has the following columns: user_id, name. The query should return the number of unique users. In the example above, the answer would be 3.
About this solution: The candidate's solution is correct and uses an efficient method to count the number of unique users.
Nov 21
Databases / SQL DifficultyMedium SQL
This technical problem deals with writing a SQL query to find the number of users who have both a first and last name. The input is a table of user data, and the output is the number of users who have both a first and last name.
About this solution: The solution above is correct and demonstrates a level of completeness. It solves the problem and takes the optimal approach by only counting the number of users who have both a first and last name.
Nov 17
Databases / SQL SQL
The table has two columns, id and data. The query should return the data in ascending order of id.
About this solution: The candidate's solution is correct and demonstrates a level of completeness. The solution is also optimal because it is the simplest solution that will return the data in ascending order of id.
Nov 11
Databases / SQL DifficultyMedium SQL
Given two tables - one of users and one of permissions - write a SQL query to find all users who have the permission to view a certain resource.
About this solution: The candidate's solution is correct and demonstrates a good understanding of SQL. The solution is also efficient, using a JOIN to combine the two tables and then filtering the results.
Nov 09
Databases / SQL DifficultyMedium SQL
This technical problem deals with writing a SQL query to find all the users who are in more than one role. The user table, role table, and user role table are provided, and the expected output is also given.
About this solution: The candidate's solution is complete and solves the problem. The approach is straightforward and easy to follow.
Nov 06