Contents Index Delete the office table Add a group to the sample database

Introducing SQL Anywhere Studio
   Tutorial: Managing Databases with Sybase Central

Lesson 3: Manage users and groups


In Adaptive Server Anywhere, both users and groups are objects within the database. However, groups are also containers, capable of containing users and other groups. When users are contained within a group, they are members of that group.

In this structure, permissions granted to a group are inherited by all users and groups contained within. Adaptive Server Anywhere allows you to create users and groups with permission to use a database and grant membership to other groups. Users and groups can be members of multiple groups.

This tutorial demonstrates how to create a group for the database, create an individual user, and make the user a member of the group.


Add a group to the sample database
Add a user to the database
Add a user to a group

Contents Index Delete the office table Add a group to the sample database