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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Managing User IDs and Permissions

Managing User IDs and Permissions Next Page

Database permissions overview

Each user of a database must have a name they enter when connecting to the database, called a user ID. Proper management of user IDs and permissions lets users of a database perform their jobs effectively, while maintaining the security and privacy of information within the database.

Database permissions are assigned to user IDs. Throughout this chapter, the term user is used as a synonym for user ID. You use SQL statements for assigning user IDs to new users of a database, granting and revoking permissions for database users, and finding out the current permissions of users.

Setting up individual user IDs

Even if there are no security concerns regarding a multi-user database, there are good reasons for setting up an individual user ID for each user. In addition to granting permissions to individual users, you can also grant permissions to groups of users. The administrative overhead is very low if a group with the appropriate permissions is set up.

You may want to use individual user IDs since:

DBA authority overview
RESOURCE authority overview
BACKUP authority overview
VALIDATE authority overview
Ownership permissions overview
Table and views permissions overview
Group permissions overview