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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database configuration » User IDs, authorities, and permissions » Permissions

 

Permissions acquired through ownership of an object

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. For example, the owner of a table can modify the structure of that table, or can grant permissions to other database users to update the information within the table.

Users with DBA authority have permission:

  • To modify any component within the database, including objects created by other users. For example, a user with DBA authority can delete a table created by another user. Users with DBA authority have all of the permissions regarding database objects that the owners of each object have.

  • To create database objects for other users. In this case, the owner of an object is not the user ID that executed the CREATE statement. In the documentation, the terms owner and creator when referring to database objects are used interchangeably.

 See also