Devart Forums

Hello,

I'm already using the dotconnect for oracle provider, and currently I'm evaluating the schema-compare tool for oracle.

I have a question about it. Does it also support the comparison of the roles/grants/users in the DB's, schema's.

Because we use quite some defined roles and grants on db-objects/tables/packages, which becomes sometimes hard to manage when moving from one DB to another.

Currently in the object-filter I see nothing which reflects to the users/roles/grants. --> is this feature already supported in the tool or maybe in the future.

PS: I did a small test (added some extra user, changed some roles...) but nothing came up in the comparison tool !!!

Please wait for the next version. It'll support privileges comparison as well as the following objects: CLUSTER, JAVA SOURCE. Also in the new version you will be able to compare and sync oracle schemas through command line interface.
We are going to release the new version of dbForge Schema Compare for Oracle in a few weeks.

Frankly speaking, the new version will support comparison of object level permissions (like GRANT SELECT, UPDATE ON emp TO user1) only. Roles and Users will not be supported, because they are not schema level objects. User level privileges (like GRANT CREATE TABLE, CREATE SYNONYM, CREATE VIEW TO user1) will not be supported either.

The second version of dbForge Schema Compare for Oracle is available now. Please try it out!