The privileges on a table describe both who can access the information in the table and who can create new tables. For more information about access privileges, see GRANT.
In an ANSI-compliant database, no default table-level privileges exist. You must grant these privileges explicitly.
Setting the environment variable NODEFDAC to yes prevents default privileges from being granted to PUBLIC on new tables in a database that is not ANSI compliant, as described in the IBM Informix Guide to SQL: Reference. For more information about privileges, see the IBM Informix Guide to SQL: Tutorial.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]