Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Database Keywords

Database Keywords

Dynamic Data Masking reserves certain keywords that the database parsers cannot parse. If you use these keywords in an SQL query when you form a rule, the query might fail. For example, if a column name in the SQL query contains one of these keywords, you might receive an invalid character error.
The following table lists the database keywords for Microsoft SQL Server and Oracle databases:
Keywords for Microsoft SQL Server Databases
Keywords for Oracle Databases
ABSOLUTE
ABSENT
APPLY
ATTRIBUTES
AT
AUTO
ATTRIBUTES
BASE64
AUTO
BEGIN
BASE64
BIGINT
BIGINT
BINARY
BINARY
BIT
BIT
BLOB
BLOB
CHARACTER
CALL
CLOB
CHARACTER
COLUMNS
CLOB
CONTENT
COLUMNS
CONVERT
CONTAINED
CROSS
CONTENT
DATETIME
DATE
DATETIME2
DATETIME
DATETIMEOFFSET
DATETIME2
DBCLOB
DATETIMEOFFSET
DEC
DEC
DECFLOAT
DECIMAL
DOCUMENT
DELAY
DOUBLE
DISABLE
ELEMENTS
DISABLE_OPTIMIZED_NESTED_LOOP
EMPTY
DYNAMIC
END
ELEMENTS
ENTITYESCAPING
EMPTY
EVALNAME
EVALNAME
EXCEPT
EXPAND
EXCLUDING
EXTERNALPUSHDOWN
EXIT
FAST
EXPLICIT
FAST_FORWARD
FIRST
FIRST
FULL
FLOAT
HOLDLOCK
FN
IF
FORCE
ILIKE
FORCED
IMAGE
FORCESCAN
INCLUDING
FORCESEEK
INDICATOR
FORWARD_ONLY
INNER
GLOBAL
INT
HASH
IREGEXP
HINT
JOIN
IIF
LARGE
IMAGE
LAST
INCLUDING
LIKE2
INDICATOR
LIKE4
INSENSITIVE
LIKEC
INT
MONEY
INTEGER
NATURAL
KEEP
NCHAR
KEEPFIXED
NO
KEYSET
NOENTITYESCAPING
LABEL
NOHOLDLOCK
LARGE
NOSCHEMACHECK
LAST
NTEXT
LEVEL
NULLS
LOCAL
NUMERIC
LOGIN
NVARCHAR
LOOP
OBJECT
MAXDOP
OFF
MAXRECURSION
OFFSET
MAX_GRANT_PERCENT
OPENXML
MIN_GRANT_PERCENT
ORDINALITY
MONEY
OUTER
NATURAL
OVER
NEXT
PARTITION
NO
PASSING
NOCOUNT
PATH
NOEXPAND
PRESERVE
NOLOCK
QUALIFY
NONE
QUOTED_IDENTIFIER
NOWAIT
REAL
NTEXT
REF
NUMERIC
REGEXP
NVARCHAR
RETURNING
OBJECT
RLIKE
OFFSET
ROOT
OPTIMISTIC
ROWCOUNT
OPTIMIZE
SAMPLE
ORDINALITY
SCHEMACHECK
OUTPUT
SEMI
PAGLOCK
SEQUENCE
PARAMETERIZATION
SHARED
PARSE
SIBLINGS
PATH
SMALLDATETIME
PRECEDING
SMALLMONEY
PRECISION
SOME
PRESERVE
STRIP
QUOTED_IDENTIFIER
SUBPARTITION
RAW
SYSTIMESTAMP
READCOMMITTED
TEXT
READCOMMITTEDLOCK
TINYINT
READPAST
USE
READUNCOMMITTED
USING
READ_ONLY
VARBINARY
REAL
WAIT
RECOMPILE
WHEN
REDISTRIBUTE
XMLAGG
REDUCE
XMLATTRIBUTES
REF
XMLCAST
RELATIVE
XMLCOLATTVAL
REPEATABLE
XMLCONCAT
REPEATABLEREAD
XMLDOCUMENT
RESULT
XMLELEMENT
ROBUST
XMLEXISTS
ROOT
XMLFOREST
ROW
XMLNAMESPACES
ROWLOCK
XMLPARSE
ROWS
XMLPI
SCROLL
XMLQUERY
SCROLL_LOCKS
XMLROW
SERIALIZABLE
XMLSERIALIZE
SETS
XMLTABLE
SIMPLE
XMLXSROBJECTID
SMALLDATETIME
SMALLINT
SMALLMONEY
SNAPSHOT
SPATIAL_WINDOW_MAX_CELLS
START
STATIC
STRING_SPLIT
SYSTEM
SYSTEM_TIME
TABLOCK
TABLOCKX
TEXT
TINYINT
TRY_CAST
TRY_CONVERT
TRY_PARSE
TYPE_WARNING
UNBOUNDED
UNDEFINED
UNKNOWN
UPDLOCK
USING
VARBINARY
VARCHAR
VIEWS
WRITE
XLOCK
XML
XMLAGG
XMLATTRIBUTES
XMLCAST
XMLCOLATTVAL
XMLCONCAT
XMLDOCUMENT
XMLELEMENT
XMLEXISTS
XMLFOREST
XMLNAMESPACES
XMLPARSE
XMLPI
XMLQUERY
XMLROW
XMLSERIALIZE
XMLTABLE
ZONE

0 COMMENTS

We’d like to hear from you!