1.324 SQL92_SECURITY
SQL92_SECURITY
specifies whether users must have been granted the SELECT
privilege on a table to execute an UPDATE
or DELETE
statement that references table column values in a WHERE
or SET
clause.
Property | Description |
---|---|
Parameter type |
Boolean |
Default value |
|
Modifiable |
No |
Modifiable in a PDB |
Yes |
Range of values |
|
Basic |
No |
The SQL standard specifies that security administrators should be able to require that users have SELECT
privilege on a table when executing an UPDATE
or DELETE
statement that references table column values in a WHERE
or SET
clause.
Values
-
true
The user must have
SELECT
privilege on a column to reference it in theWHERE
clause of aDELETE
orUPDATE
statement, on the right hand side of an assignment in theSET
clause of anUPDATE
statement. -
false
A user with
DELETE
privilege on the target table of aDELETE
statement may reference any column of that target table in theWHERE
clause. A user withUPDATE
privilege on the target table of anUPDATE
statement may reference any column of that target in theWHERE
clause or on the right hand side of any assignment in theSET
clause of theUPDATE
statement.