ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

The stored-routine privileges are contained in . . . . . . . .

Answer & Solution
Correct Answer: Option D
This question asks about where MySQL stores the permissions for stored routines, like procedures and functions. Stored routines are powerful tools that allow you to create reusable blocks of code within your database.

Let's look at the options:

Option A: user – This refers to individual users and their access privileges. It doesn't directly store routine permissions.

Option B: db – This refers to the database itself. While the database holds the routines, it doesn't store the specific permissions for executing them.

Option C: tables_priv – This table stores permissions related to tables, like INSERT, UPDATE, and DELETE. It doesn't handle stored routine permissions.

Option D: procs_priv – This is the correct answer! The procs_priv table specifically stores permissions for stored routines, including who can execute them.

So, the procs_priv table holds all the information about which users are allowed to create, modify, and execute stored procedures and functions in a MySQL database.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.