Grant Manager.
Using the Grant Manager tool you may grant or revoke privileges tousers and
objects, grant users to roles and revoke them.
Grant Manager requires access to the securiry information of your server. This
can be done by tree ways:
- Connecting to the security service manager of your server. Becase the Services
API is available only under Interbase 6.0 and later versions you can use is
only with Interbase 6.0 or later versions. Your server must be registered
before opening Grant Manager to provide nessesary information about your server.
- Connecting directly to the security database (isc4.gdb and admin.gdb for
Interbase 7.0). This database contains all information about users registered
on your server. If you have a SYSDBA password you may connect to this database.
This works with all versions of Interbase. To use this mode just provide the
information about isc4.gdb path, login and password and click "Connect"
button.
- Collecting the user information from the database. You can use this mode
when you have no access to the security database or not know the path to this
database. The list of users and roles will be build upon existing privilege
information of your database. So you may grant or revoke some provileges only
to users that always have some privileges. To use this mode just click on
"click here if you have no access to the security database" flag.
When connected you may start to manage your privilege information. There are
4 pages available in Grant Manager:
- Users to Objects
- Objects to Users
- Objects to Objects
- Roles
On the first page (Users to Objects) you have to select user and change his/her
privileges. You may grant all privileges on selected object or grant separate
privilege on all objects.
On the second page (Objects to Users) you have to select object and change
users right to this object.
On the third page (Object to Object) you have to select object and manage its
rights on another objects. I.e. procedure can have SELECT privilege on the Table.
And on the fourth page you can include or exclude users from Roles.
At all pages roles are listed with users.
Use mouse double-click to grant or revoke privileges. If you need to grant
privileges with GRANT OPTION use menu commands instead.