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 » Database permissions overview

VALIDATE authority overview Next Page

Ownership permissions overview

The creator of a database object becomes the owner of that object. Ownership of a database object carries with it permissions to perform actions on that object. These permissions are not assigned to users in the same way that other permissions in this chapter are assigned.


A user who creates a new object within the database is called the owner of that object, and automatically has permission to perform any operation on that object. The owner of a table may modify the structure of that table, for instance, or may grant permissions to other database users to update the information within the table.

The DBA has permission to modify any component within the database, and so could delete a table created by another user. The DBA has all the permissions regarding database objects that the owners of each object have. As well, the DBA can also create database objects for other users. In this case, the owner of an object is not the user ID that executed the CREATE statement. Despite this possibility, this chapter refers interchangeably to the owner and creator of database objects as the same user.

See also