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 (Sybase Central)

 

Lesson 1: Create two new users: User1 and User2 (Sybase Central)

Log in to the sample database using Sybase Central and create two new users.

Prerequisites

None.

 Task

  1. Start Sybase Central and connect to the database.

    1. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

    2. Click Connections » Connect With SQL Anywhere 16.

    3. In the Action dropdown list, select Connect with an ODBC Data Source.

    4. In the ODBC Data Source name, click Browse, select SQL Anywhere 16 Demo, and then click OK.

    5. Click Connect. This connects you to the sample database as the user called DBA, with the password sql, and with full administrative rights on the database.

  2. Create two new users.

    1. In the left pane, right-click Users and then click New » User.

    2. In the What do you want to name the new user? field, type User1, then click Next.

    3. Assign the password sql to User1, then click Finish.

    4. Repeat the above steps to create the second user, User2.

Results

You have created two new users, User1 and User2.

Next

Proceed to Lesson 2: Grant privileges to User1 (Sybase Central).

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0