dbForge schema compare oracle --> roles, grants, .. support?

dbForge schema compare oracle --> roles, grants, .. support?

Postby goethals.f » Wed 18 May 2011 12:44

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 !!!
goethals.f
 
Posts: 60
Joined: Mon 18 May 2009 13:17

Postby .jp » Wed 18 May 2011 13:35

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.
.jp
Devart Team
 
Posts: 303
Joined: Wed 09 Sep 2009 06:55
Location: devart

Postby .jp » Wed 18 May 2011 13:52

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.
.jp
Devart Team
 
Posts: 303
Joined: Wed 09 Sep 2009 06:55
Location: devart

Postby .jp » Fri 03 Jun 2011 08:58

The second version of dbForge Schema Compare for Oracle is available now. Please try it out!
.jp
Devart Team
 
Posts: 303
Joined: Wed 09 Sep 2009 06:55
Location: devart


Return to dbForge for Oracle