Chapter 13 Managing Database Access
In the database The user who creates an object (table, view, stored procedure and so on) owns this object and is automatically granted all permissions on it.
For more information on object permissions, see section Managing object permissions.
In the PDM You have to attach a user to an object in order to make it become the owner of the object. Each object can only have one owner at a time. For example, when you create a table, by default the object has no owner. You can select a user name from a list of users, and attach it to the table. This user then becomes the owner of the table.
Owners are used to manage object modifications in a PDM. In a model where many users have access to the same objects, you can restrict object modifications to the owner and define permissions for the other users.
Owners can also be used during generation: when you select to generate for a selected owner, only the tables belonging to this owner are generated, whereas when you generate as ADMIN, you generate all the tables on behalf of all their owners.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |