Privileges related to cursor data type use
Specific privileges related to cursor data types and variables exist to restrict and control who can create them.
To create cursor data types, you require the following privilege:
- Privilege to execute the CREATE TYPE statement to create a cursor data type.
To declare cursor variables based on existing cursor data types, no privileges are required.
To initialize cursor variables, to open the cursor referenced by a cursor variable, or to fetch values from an opened cursor variable reference, you require the same privileges as are required to execute the DECLARE CURSOR statement.