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.
Users with DBA authority have permission to modify any component within the database, and so could delete a table created by another user. They have all the permissions regarding database objects that the owners of each object have. As well, users with DBA authority 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, the owner and creator of database objects as the same user are referred to interchangeably.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|