Which of the following are true in relation to stored procedures and functions?
When defining a stored procedure or function the SQL SECURITY characteristic can be used to …
A.
specify what privileges are required to execute it.
B.
specify which users are allowed to execute it.
C.
specify whether it runs as the user executing it or the user who created it.
D.
give users controlled access to tables via the routine without giving them the ability to query them directly.