Skip to main content

Search

Welcome to Tibero GTS!

How to Use Special Characters and Case Sensitivity When Creating DB Users

Document Type | Technical Information

Category | Administration

Applicable Product Version | 7FS02PS

Document Number | TADTI051

 

Overview

When creating a user, quotation marks are required to distinguish case sensitivity or to apply special characters.
In Tibero, double quotation marks (โ€œโ€) are required when using special characters, and single quotation marks ('') must be used for case sensitivity.
The following examples guide you on how to apply special characters and case sensitivity when creating users.
 
 

Method

Applying Special Characters

Case 1. Using Double Quotation Marks

SQL> CREATE USER TEST4 IDENTIFIED BY "Test123!";

User 'TEST4' created.

SQL> grant connect, resource to TEST4;

Granted.


Case 2. Using Single Quotation Marks

SQL> CREATE USER TEST3 IDENTIFIED BY 'Test123!';

User 'TEST3' created.

SQL> grant connect, resource to TEST3;

Granted.


Case 3. Not Using Quotation Marks

Creation is not possible.

SQL> CREATE USER TEST5 IDENTIFIED BY TEST5!;

TBR-23006: Invalid not equal (!=) operator.
at line 1, column 38 of null:


CREATE USER TEST5 IDENTIFIED BY TEST5!

 

Applying Case Sensitivity

Case 1. Attempting to Connect with User Created Using Single Quotation Marks

Single quotation marks are case-sensitive, so if the input differs from the created characters, connection will fail. Connect by entering the case exactly.
SQL> CONN TEST3/'TEST123!';
TBR-17001: Login failed: invalid user name or password.

No longer connected to server.


-- Successful connection using single quotation marks
SQL> CONN TEST3/'Test123!';
Connected to Tibero.

-- Successful connection using double quotation marks
SQL> CONN TEST3/"Test123!"
Connected to Tibero.

 

Case 2. Attempting to Connect with User Created Using Double Quotation Marks

Double quotation marks are not case-sensitive, so connection is possible regardless of case.
-- Case sensitivity_Connection successful
SQL> CONN TEST3/"Test123!"
Connected to Tibero.

-- Using double quotation marks, case-insensitive_Connection successful
SQL> CONN TEST4/"TeSt123!"
Connected to Tibero.

-- Using single quotation marks, case-insensitive_Connection successful
SQL> CONN TEST4/'TEst123!';
Connected to Tibero.

Note

The above examples were performed on Tibero 6 FS07.

 

 

 

Related to