Access Control for MySQL Stored Programs and Views


  1. A stored procedure is invoked using the statement __________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    In MySQL, a stored procedure is invoked using the CALL statement. A stored procedure does not have a return value but can modify its parameters. It also returns some result sets.


  1. Triggers and events are invoked automatically by the server.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    The triggers and events are invoked automatically by the server, so the concept of invoking user is not applied. Thus, they have no SQL SECURITY characteristic and always execute with definer privileges.



  1. When a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access, the security context is __________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The security context is bad if a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access to that data as its definer.


  1. When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The security context is good if it enables carefully written stored programs to be set up that provide controlled access to tables for users who are not able to access them directly.



  1. The creation of a stored program is similar to the definition of a _______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    When a stored program is created, an object is created that is to be executed later. This also the case when a view is defined: It sets up a SELECT statement intended for later invocation.