Toad World® Forums

Generation of permissions


#1

Hi,

As you may recall we have customised generation scripts to create separate files for various parts of the database creation script.

We used to generate the permissions by just setting “Permissions to Objects”.

However in TDM 3.4.15.10 nothing is generated unless Entities, etc are also selected.
This has the side effect of generating the code for the entities, etc and is not what we want to do.

Is there a way I can get just the permissions?
Or will I need to manipulate the output in the script?

Regards
Malcolm


#2

Hello Malcolm,

We used to generate the permissions by just setting “Permissions to Objects”.

Yes, this behavior was considered as a bug that was already fixed.

Now it works this way:
If entities are not generated, permissions for entities are not generated either.
It works the same way even for individual entities: If an entity has clear checkbox “Generate”, the entity will not be generated and its permission either.

Anyway, we can make a user package that will do what you need. Please let us know if you want the package and for which databases we should make it.

Thanks.

Regards,

Vladka + TDM Team


#3

Hi Vladka,

this behavior was considered as a bug
I think this is right in the grand scheme of things.

I have hacked our script to generate the table, etc as well then extract the permissions part. This solution will suffice.

Thanks

Malcolm


#4

Hi Malcolm,

O.K. Thanks.

Have a nice day.

Vl.