Lesson 1: Create two users: UserA and UserB (SQL)

Log in to Sybase Central as user ID DBA and create two new users who will be responsible for backing up the sample database, debugging procedures, and correcting any mistakes found during the debug process.

Prerequisites

None.

Task

Start Sybase Central.
1. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.
2. Click Tools » SQL Anywhere 16 » Open Interactive SQL.
  
  Complete the following fields to connect to the sample database:
  1. In the User ID field, type DBA.
  2. In the Password field, type sql.
  3. In the Action dropdown list, select Connect to a running database on this computer.
  4. In the Server Name field, type demo16.
  Click Connect. Interactive SQL connects to the database.

Create two new users.

Execute the following statement to create UserA:

CREATE USER UserA IDENTIFIED BY sql;

Execute the following statement to create UserB:

CREATE USER UserB IDENTIFIED BY sql;

Results

You have created two new users, UserA and UserB.

Next

Proceed to Lesson 2: Grant privileges to UserA (SQL).

Lesson 1: Create two users: UserA and UserB (SQL)

Task

See also