Chapter 13 Managing Database Access


Analyzing object permissions

Object permissions are restricted to certain PDM objects and vary according to the DBMS you are using:

Permission Description
Select To observe information contained in object
Insert To insert rows into object
Alter To alter table with ALTER TABLE command
Delete To delete rows from object
References To create indexes in tables and foreign key referencing tables
Update To update row in object
Index To create an index with the CREATE INDEX command
Execute To execute procedure or function

For more information on the permissions allowed in your DBMS, see your DBMS documentation.

Object owner

The owner of an object automatically has permission to carry out any operation on that object. These permissions do not appear in the Permissions page of the object property sheet but they are implemented during generation and reverse engineering.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.