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
ANY_VALUE
AT
APPROX_COUNT
ATTRIBUTES
APPROX_COUNT_DISTINCT
AUTO
APPROX_COUNT_DISTINCT_AGG
BASE64
APPROX_COUNT_DISTINCT_DETAIL
BIGINT
APPROX_MEDIAN, DETERMINISTIC
BINARY
APPROX_PERCENTILE, DETERMINISTIC
BIT
APPROX_PERCENTILE_AGG
BLOB
APPROX_PERCENTILE_DETAIL
CALL
APPROX_SUM,APPROX_RANK
CHARACTER
ATTRIBUTES
CLOB
AUTO
COLUMNS
BASE64
CONTAINED
BEGIN
CONTENT
BIGINT
DATE
BINARY
DATETIME
BIT
DATETIME2
BLOB
DATETIMEOFFSET
CHARACTER
DEC
CLOB
DECIMAL
COLUMNS
DELAY
CONTENT
DISABLE
CONVERT
DISABLE_OPTIMIZED_NESTED_LOOP
COLLATE
DYNAMIC
CONNECT BY PRIOR
ELEMENTS
CONNECT_BY_ISCYCLE
EMPTY
CONNECT_BY_ISLEAF
EVALNAME
CONNECT_BY_ROOT
EXPAND
CONTAINERS
EXTERNALPUSHDOWN
CONTAINS
FAST
CROSS
FAST_FORWARD
CURSOR
FIRST
DATETIME
FLOAT
DATETIME2
FN
DATETIMEOFFSET
FORCE
DAYS
FORCED
DBCLOB
FORCESCAN
DEC
FORCESEEK
DECFLOAT
FORWARD_ONLY
DOCUMENT
GLOBAL
DOUBLE
HASH
ELEMENTS
HINT
EMPTY
IIF
END
IMAGE
ENTITYESCAPING
INCLUDING
EVALNAME
INDICATOR
EXCEPT
INSENSITIVE
EXCLUDING
INT
EXIT
INTEGER
EXPLICIT
KEEP
FETCH
KEEPFIXED
FIRST
KEYSET
FULL
LABEL
HOLDLOCK
LARGE
HOUR
LAST
IF
LEVEL
ILIKE
LOCAL
IMAGE
LOGIN
INCLUDING
LOOP
INDICATOR
MAXDOP
INNER
MAXRECURSION
INT
MAX_GRANT_PERCENT
IREGEXP
MIN_GRANT_PERCENT
JOIN
MONEY
JOINS
NATURAL
LARGE
NEXT
LAST
NO
LIKE2
NOCOUNT
LIKE4
NOEXPAND
LIKEC
NOLOCK
LOCKED
NONE
MONEY
NOWAIT
MONTHS
NTEXT
MULTISET
NUMERIC
NATURAL
NVARCHAR
NCHAR
OBJECT
NO
OFFSET
NOENTITYESCAPING
OPTIMISTIC
NOHOLDLOCK
OPTIMIZE
NOSCHEMACHECK
ORDINALITY
NTEXT
OUTPUT
NULLS
PAGLOCK
NUMERIC
PARAMETERIZATION
NVARCHAR
PARSE
OBJECT
PATH
OFF
PRECEDING
OFFSET
PRECISION
OPENXML
PRESERVE
ORA_SHARD_ID
QUOTED_IDENTIFIER
ORDINALITY
RAW
OUTER
READCOMMITTED
OVER
READCOMMITTEDLOCK
PARTITION
READPAST
PASSING
READUNCOMMITTED
PATH
READ_ONLY
PRESERVE
REAL
QUALIFY
RECOMPILE
QUOTED_IDENTIFIER
REDISTRIBUTE
REAL
REDUCE
REF
REF
REGEXP
RELATIVE
RETURNING
REPEATABLE
RLIKE
REPEATABLEREAD
ROOT
RESULT
ROUND_TIES_TO_EVEN
ROBUST
ROWCOUNT
ROOT
SAMPLE
ROW
SCHEMACHECK
ROWLOCK
SEMI
ROWS
SEQUENCE
SCROLL
SHARDS
SCROLL_LOCKS
SHARED
SERIALIZABLE
SIBLINGS
SETS
SMALLDATETIME
SIMPLE
SMALLMONEY
SMALLDATETIME
SOME
SMALLINT
STRIP
SMALLMONEY
SUBPARTITION
SNAPSHOT
SYS_CONNECT_BY_PATH
SPATIAL_WINDOW_MAX_CELLS
SYSTIMESTAMP
START
TEXT
STATIC
TINYINT
STRING_SPLIT
TO_UTC_TIMESTAMP_TZ
SYSTEM
UPDATE
SYSTEM_TIME
USE
TABLOCK
USING
TABLOCKX
VARBINARY
TEXT
WAIT
TINYINT
WHEN
TRY_CAST
WITH
TRY_CONVERT
XMLAGG
TRY_PARSE
XMLATTRIBUTES
TYPE_WARNING
XMLCAST
UNBOUNDED
XMLCOLATTVAL
UNDEFINED
XMLCONCAT
UNKNOWN
XMLDOCUMENT
UPDLOCK
XMLELEMENT
USING
XMLEXISTS
VARBINARY
XMLFOREST
VARCHAR
XMLNAMESPACES
VIEWS
XMLPARSE
WRITE
XMLPI
XLOCK
XMLQUERY
XML
XMLROW
XMLAGG
XMLSERIALIZE
XMLATTRIBUTES
XMLTABLE
XMLCAST
XMLXSROBJECTID
XMLCOLATTVAL
XMLCONCAT
XMLDOCUMENT
XMLELEMENT
XMLEXISTS
XMLFOREST
XMLNAMESPACES
XMLPARSE
XMLPI
XMLQUERY
XMLROW
XMLSERIALIZE
XMLTABLE
ZONE

0 COMMENTS

We’d like to hear from you!