Architecture and Administration Q016

When a SELECT statement is issued, which stage checks the user's privileges?



1. Parse
2. Fetch
3. Execute



Answer 1 - The parse compiles the SQL statement if there is not an already parsed statement available in the library cache and then checks the privileges. The next stage is the execution stage, when the parsed code is executed. In the fetch stage rows are returned to the user.