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

Subscribe to our news:
Partners
Testimonials
Stephen Arrowel, Database Administrator: "We are in the process of implementing Firebird solutions at multiple levels in our international organization. We expect that SQL Maestro Group will do nothing short of revolutionize the way we develop and maintain our Firebird databases. The continuous improvement and development means that the product is extremely flexible and will grow with us. The service and responsiveness of the Support Team has been exceptional. They have devoted countless hours to understanding our needs, so that we could get a Firebird administration tool which would be so simple and effective in use. SQL Maestro Group is helping Sytrax sail into the 21st Century".
Brian Vivian: "Thank you very much for making such a great product. It makes my job a LOT easier".

More

Add your opinion

Firebird Maestro online Help

Prev Return to chapter overview Next

Object grants

The Grants grid allows you to manage access privileges (grants) of the current object.

 

A grant gives specific privileges on an object (table, view, procedure) to the current one.

 

All objects are grouped by kind. Filter the object kinds using the checkboxes at the bottom of the window. Using the grid you may sort and filter data.

 

 

To grant the subject privilege on the object double-click an empty field; to revoke the privilege double-click a grant with grant option.

 

Use grid’s popup menu to grant, grant all, grant with grant option, grant all with grant option, grant on all, grant on all with grant option, revoke, revoke all and revoke on all:

 

select the Grant item to grant the subject privilege on the object;
select the Grant All item to grant all the privileges on the object;
if the Grant With Grant Option item is selected, the recipient of the privilege may in turn grant it to others (without a grant option specified, the recipient cannot do that; at present, grant options can only be granted to individual subject, not to groups or Public);
select the Grant All With Grant Option item to grant with grant options the privilege on all the objects of the kind;
select Grant On All or Grant On All With Grant Option to grant or grant with grant options respectively the subject privilege on all the objects;
to revoke the privilege, all the privileges on the object or the privileges on all the server objects select the Revoke, Revoke All or Revoke On All items respectively.

 

Using the popup menu you can also collapse or expand all the object kinds.



Prev Return to chapter overview Next