Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking
  3. Rules
  4. Connection Rules
  5. Security Rules
  6. Security Rule Set Simulator
  7. Masking Functions
  8. Stored Procedure Result Set Masking
  9. Integration with Informatica Products
  10. Appendix A: XML Functions Reference
  11. Appendix B: Glossary

User Guide

User Guide

Sybase Session Changing Commands

Sybase Session Changing Commands

The following table lists the session changing commands you can use with a Sybase database:
SQL Command
Description
Syntax
Masking is Affected
USE (Transact-SQL)
Changes the database context to the specified database or database snapshot in Sybase.
USE {database_name} [;]
Yes
SET QUOTED_IDENTIFIER (Transact-SQL)
Causes Sybase to follow the ISO rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transact-SQL reserved keywords or can contain characters not generally allowed by the Transact-SQL syntax rules for identifiers.
SET QUOTED_IDENTIFIER { ON | OFF }
Yes
SETUSER
Allows a database owner to impersonate another user.
SETUSER["USER_NAME"]
Yes
SET PROXY
Restricts which roles cannot be acquired when switching identities.
SET PROXY USER|ROLE
Yes
The following table lists examples of the SQL commands in use:
Description
Example
SQL block that contains USE followed by SELECT statement.
USE DDM SELECT * FROM EMPLOYEE
SQL block that contains SET QUOTED_IDENTIFIER followed by SELECT statement.
SET QUOTED_IDENTIFIER OFF SELECT * FROM EMPLOYEE
SQL block that contains SETUSER followed by SELECT statement.
SETUSER 'ddmuser1' SELECT * FROM EMPLOYEE
SQL block that contains SET PROXY followed by SELECT statement.
SET PROXY ddmuser1 SELECT * FROM EMPLOYEE
SQL block that contains only session changing commands.
USE DDM SET QUOTED_IDENTIFIER OFF