NODEFDAC

When the NODEFDAC environment variable is set to yes, it prevents default table privileges (Select, Insert, Update, and Delete) from being granted to PUBLIC when a new table is created in a database that is not ANSI compliant. If you do not set the NODEFDAC variable, it is, by default, set to no.

                     .-no--.
>>-setenv--NODEFDAC--+-yes-+-----------------------------------><

no

allows default table privileges to be granted to PUBLIC. Also allows the Execute privilege on a new user-defined routine to be granted to PUBLIC when the user-defined routine is created in Owner mode.

yes

prevents default table privileges from being granted to PUBLIC on new tables in a database that is not ANSI compliant. This setting also prevents the Execute privilege for a new user-defined routine from being granted to PUBLIC when the routine is created in Owner mode.