Sync script does not include differences in permissions for existing tables.

[Ash]

Hi,

I'm using DBSolo to schema compare two Oracle 10g databases.

However, it doesn't look as though DBSolo generate differences (in the
sync script) for permissions between tables that already exist.

For example:

DB1 and DB2 both already have a table called TABLE1. On DB2, TABLE1
has an extra insert permission granted to USER1.

Upon performing a schema diff and viewing the generated sql I can't
see the additional grant being given to USER1 on TABLE1 on DB1.

Thanks.

[DB Solo Admin]

Hi,

Can you download the latest from dbsolo.com/preview. Notice that
permissions are not compared by default, you need to enable that
feature explicitly on the settings page.

marko

[Ash]

Thanks for that. Downloading version 3.7.5 fixed that issue.

Also in future, will there be a feature to filter the compared
permissions based on the grantee?
E.g. I only want to compare differences in permissions on TABLE1 where
the grantee is USER1 - is this feature in the roadmap and likely to be
implemented soon?

Thanks.

[DB Solo]

Yes, this is on the roadmap.

Marko