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

Subscribe to our news:
Partners
Testimonials
Paul Slicky: "I just want to say this has been the fastest, greatest, and most coopertive tool I have ever had. It turned out to be easy to use and very slick. Keep up the good work".
Dan Flazer: "Your new product and your assistance with us was excellent...will prove invaluable to the future of our company".

More

Add your opinion

MaxDB Maestro online Help

Prev Return to chapter overview Next

Managing group grants

The Grants grid allows you to manage access privileges (grants) of groups.

 

Grant gives specific privileges on an object (table, view, sequence, database, function, procedural language, schema or tablespace) to one or more users or groups of users.

 

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

 

 

To grant the group 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 on all, revoke, revoke all and revoke on all:

 

select the Grant item to grant the group privilege on the object;
select the Grant All item to grant all the privileges on the object;
select Grant On All to grant the group privilege on all the server 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