Object permissions are operations attached to particular database objects.
PowerDesigner allows you to define permissions on tables, views, columns, procedures, packages, and other objects depending on your DBMS. Some or all of the following may be available
|
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.
The owner of an object (see Assigning an owner to an object) automatically has permission to carry out any operation on that object. These permissions do not appear in the Permissions tab of the object property sheet but they are implemented during generation and reverse engineering.