Database security /* Q5. Assuming the login \'Anna\' is the user \'assistant\' o

Question

Database security

/* Q5.
Assuming the login 'Anna' is the user 'assistant' of the Clearwater database in your server,
write one GRANT statement to perform two tasks: (1) allow this user to create new tables in
Clearwater, and (2) allow this user to grant the same permission (i.e., creating new tables
in Clearwater) to other users.
*/

/* 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

Hi,

Ans 5-
PART 1 - GRANT CREATE TABLE ON CLEARWATER TO ASSISTANT;
PART 2 - GRANT CREATE SESSION GRANT ANY PRIVILEGE ON CLEARWATER TO ASSISTANT;

Ans 10- REVOKE CREATE SESSION GRANT ANY PRIVILEGE ON CLEARWATER TO ASSISTANT CASCADE ALL;

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.