Security Manager

The Security Manager provides you with the functionality required to view and edit database object permissions, edit user and role permissions and automatically recover permissions of the objects modified in the SQL Editor.

Users Explorer Users Explorer is added to the basic Object Explorer. You can add new users to a database or modify the existing user permissions. You can also assign users to a role and grant database objects permissions to a user.

Roles Explorer You can view existing roles and create new roles. You can assign users to a role and define object permissions to a role.

Database Object Permissions For each database object, such as a table or stored procedure, you can view list of existing user permissions and grant/revoke permissions to a single or multiple users and roles. All parameters of GRANT and REVOKE statements are supported in the visual permission editor.

Replicate Object Permissions You can replicate permissions of a selected user or role to any group of users or roles. It is very useful function, when adding new users who should have the same permissions as one of already existing users.

Recovery of existing object permissions Editing an existing database object, such as stored procedure or view, requires dropping an object and re-creating it afterwards. This operation loses the existing object permissions and they have to be recovered after each object modification. Security Manager solves this problem by applying all previous object permissions to an object after if is modified in the SQL Editor.

Users Explorer	Users Explorer is added to the basic Object Explorer. You can add new users to a database or modify the existing user permissions. You can also assign users to a role and grant database objects permissions to a user.
Roles Explorer	You can view existing roles and create new roles. You can assign users to a role and define object permissions to a role.
Database Object Permissions	For each database object, such as a table or stored procedure, you can view list of existing user permissions and grant/revoke permissions to a single or multiple users and roles. All parameters of GRANT and REVOKE statements are supported in the visual permission editor.
Replicate Object Permissions	You can replicate permissions of a selected user or role to any group of users or roles. It is very useful function, when adding new users who should have the same permissions as one of already existing users.
Recovery of existing object permissions	Editing an existing database object, such as stored procedure or view, requires dropping an object and re-creating it afterwards. This operation loses the existing object permissions and they have to be recovered after each object modification. Security Manager solves this problem by applying all previous object permissions to an object after if is modified in the SQL Editor.