agree with C. I took the least privileges only.
C -> Query OK, 1766 rows affected (0.0211 sec)
Rows matched: 1766 Changed: 1766 Warnings: 0
D-> ERROR: 1143: SELECT command denied to user 't***h'@'localhost' for column 'CountryCode' in table 'city'
Sorry for changing my answers.
C. read and write to city, read from country, and two columns from country need to be read. Only C works.
A won't work because you need to read from two columns in country, not just one.
B won't work because you need to read from city.
D won't work because you need to read from city as well.
city need to read and write, it needs to read CountryCode. Thus A, all privs includes read.
BCD and all work if you just need to update city and read from country.
Not sure why B and C won't work. Especially C, since it includes D
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
LrnsTgh
6 months, 4 weeks agomarklv
7 months, 3 weeks agomarklv
9 months, 3 weeks agoFelipeK
10 months agomarklv
11 months, 1 week ago