Search

User Guide

User Guide

9.9.2
- 9.9.4
- 9.9.3
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

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

Session Changing Commands

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.