Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Andrey Bistriy: "In our daily business we face the database management and refactoring. We were pleasantly surprised to discover SQL Maestro. After trying it out we started to use it on a regular basis".
Neil McPherson: "Thanks very much for your advice. I would just like to add that SQL Maestro makes life so much easier to work with Firebird, I have tried some of the other management tools but Maestro is such a nicely organized product and it has never let me down".

More

Add your opinion

Firebird Maestro online Help

Prev Return to chapter overview Next

Overview of Object Editors

Database Object Editors are the basic Firebird Maestro tools for working with existing objects. The proper editor can be opened automatically after the object is created. You can also open the necessary object editor with the corresponding items of popup menus of the Explorer Tree, Object Manager or Object Browser.

 

The editors consist of a several tabs. Some tabs are similar for all editors. This part purpose is to formulate the basic principles of all Object Editors in Firebird Maestro.

 

To edit object options such as name, owner, etc. use the Properties tab. To understand an option, see the appropriate topic of the corresponding Object Editor manual section and Firebird documentation.

 

       This tab also allows you to manage objects belonging to the selected one. To reset any tab to default settings, open it when holding the Ctrl key.

 

Use the Permissions tab to manage access privileges (grants) of the corresponding object.

 

In a similar manner, some objects called grantees (e.g. users or roles) can have rights to do something with other objects (e.g. a user can read data from a table). This relationship can be set up at the Grants tab.

 

Object correlation with another Firebird objects is represented on Dependencies.

 

Most of objects have a possibility to be created from an SQL script (SQL definition). If so, the corresponding script is available at the SQL tab of the editor.

 

There is a Result tab in editors of such routines as functions and procedures that can take parameters, perform calculations or other actions, and return a result. You can execute any routine directly from its editor.

 

Note: Some object editors have additional tabs. The detailed description of them you can find at the appropriate topic of the corresponding section.

 

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

 

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.

 

See also:



Prev Return to chapter overview Next