What is the lowest privilege and/or authority required to execute the following SQL statement?
CREATE VIEW view1 AS
SELECT * FROM table1
WHERE STATE = ‘TX’
A.
DBADM authority
B.
SYSADM authority
C.
SELECT privilege on TABLE1
D.
REFERENCES privilege on TABLE1
Authorization
The privileges held by the authorization ID of the statement must include at least one of the following:
IMPLICIT_SCHEMA authority on the database, if the implicit or explicit schema name of the view does not exist
CREATEIN privilege on the schema, if the schema name of the view refers to an existing schema
DBADM authority
and at least one of the following for each table, view, or nickname identified in any fullselect:
CONTROL privilege on that table, view, or nickname
SELECT privilege on that table, view, or nickname
DATAACCESS authority
0
0