Question discussion

In order to grant a user named 'Deepak' the ability to read data from a table called 'Customers', which SQL statement should be used?

359024Medium DSSSB TGT Computer Science 0 replies 0 views
0
In order to grant a user named 'Deepak' the ability to read data from a table called 'Customers', which SQL statement should be used?
  • AGRANT SELECT ON Customers TO Deepak;
  • BGRANT READ ON Customers TO Deepak;
  • CGRANT ACCESS ON Customers TO Deepak;
  • DGIVE SELECT ON Customers TO Deepak;
Correct answer: A

Explanation

The SQL syntax for giving read permission is GRANT SELECT ON table TO user, so option 1 is correct.

Discussion 0

Nobody has replied yet. Start the discussion!