#3 Make the installation public synoyms and grants optional

[Michael J. O'Neill]

It is rare that I allow any public synonyms in my
database. Although it isn't much of a pain to remove the
newly created public synonyms, I wish that it would at
least be optional that they be created in the first place.

[Michael J. O'Neill]

Logged In: YES
user_id=437792

The same notion for public grants too.

[Paul Walker]

I can't see why not. Looking at the initial install script (ut_i_do.sql), one of the parameters you can specify will install the synonyms (runs ut_i_synonyms.sql).

My thinking is that we could add a similar option to that script to setup the grants (ut_i_grants.sql) then remove both sripts from ut_i_install.sql.

This would mean that to do a full install, including synonyms and grants, you'd have to run ut_i_do.sql three times:

@@ut_i_do install
@@ut_i_do synonyms
@@ut_i_do grants

Doesn't seem like a big price to pay for the extra flexibility.

Any thoughts/concerns from anyone before I set this to Verified?

[Paul Walker]

Another thought is that for the sake of compatibility, the install option should work the same as it's always done. In that case, we either need a way to indicate that we don't want to do grants and/or synonyms, or we have additional install options that will skip the relevant scripts.

This could be done by having more install options (ie @@ut_i_do install-nosynonyms, @@ut_i_do install-nogrants and @@ut_i_do install-nosynonyms-nogrants) but this seems a bit cumbersome.

Another way would be to allow extra parameters. Currently, when running @@ut_i_do, the first parameter is used to indicate the action (eg install). The script could probably be modified to check for a second and third parameter. If either of them contain nogrants or nosynonyms then those scripts would be skipped from the install.

[MikeV]

Hi there,

I just started using utplsql and wondered if it was possible to skip the public synonyms and grants. Too bad it is not there yet ;) My preference would be to add the second and third parameter.

[Paul Walker]

I'm inclined to agree - allow the script to accept additional parameters of nogrants and nosynonyms

As a workaround, you can edit ut_i_install.sql. The calls to setup the grants and synonyms are at the very end - just comment out/remove whatever you don't want...

----------------------------------------------------GENERIC SCRIPTS

@@ut_i_synonyms

@@ut_i_grants

[Paul Walker]

Unless anyone else has any opinions to offer, I suggest we proceed with the following:

Modify the installation script so that it accepts additional switches:

@ut_i_do install [nogrants] [nosynonyms]

• If nogrants is specified, then ut_i_grants.sql is not run.
• If nosynonyms is specified, then ut_i_synonyms is not run.

Either of these switches can be specified on their own, or both together (the order of the must not matter)