explain access control lists. : Sql dba
Answer / Sawan Kumar
Access Control Lists (ACLs) in MySQL are used to control access to database objects such as tables, views, procedures, and functions. They allow you to specify which users or groups of users can perform certain operations on these objects.nFor example, you can create an ACL that allows user 'john' to SELECT data from table 'employees', but not INSERT, UPDATE, or DELETE data.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a call statement? Explain with an example.
Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
Why is normalization important?
What found sql?
Can you sum a count in sql?
How do I remove sql developer from windows 10?
How do you respond to dementia behavior?
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
How do you select unique values in sql?
What operators deal with null?
what are wild cards used in database for pattern matching ? : Sql dba
Does mysql_real_escape_string prevent sql injection?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)