Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges) » Tutorial: Granting roles and privileges (SQL)

 

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.

Prérequis

None.

 Task
  1. 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.

  2. Create two new users.

    1. Execute the following statement to create UserA:

      CREATE USER UserA IDENTIFIED BY sql;
    2. Execute the following statement to create UserB:

      CREATE USER UserB IDENTIFIED BY sql;

Résultat

You have created two new users, UserA and UserB.

 See also