/* Q10. In Q5, you have granted the \'assistant\' user a permission of CREATE TA
ID: 3711472 • Letter: #
Question
/* Q10. In Q5, you have granted the 'assistant' user a permission of CREATE TABLE in the Clearwater database and also allowed this user to grant the same permission to other users of this database. A big concern and risk of doing so is the 'assistant' user and everyone who was granted this permission can keep granting to more and more other users, which may become out of your expectation eventually. To stop and prevent the 'assistant' user and all who were granted such permission from granting to even more other users, what statement will you execute? */
Explanation / Answer
We will simply run REVOKE command to take back create table privilage from 'assistant' user so that either it and other user who were granted such permission by 'assistant' could not run create table command on Clearwater database.
REVOKE CREATE TABLE ON Clearwater FROM assistant;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.