|
|
|
Valid in: SQL, ESQL
The Remove Table statement removes the registration of a security log file.
|
|
|
The Remove Table statement has the following format:
[EXEC SQL] REMOVE TABLE [schema.]table_name
{, [schema.]table_name}C2 SECURITY;
|
|
|
The Remove Table statement removes the mapping of a file to a virtual table. To map files to virtual tables, use the REGISTER TABLE statement. The REMOVE TABLE statement removes security log files that were registered using the REGISTER TABLE...AS IMPORT statement.
Note: This statement is not the same as the REMOVE statement, which is described in the Ingres Star User Guide.
|
|
|
No portion of an embedded Remove Table statement can be specified using host language variables.
|
|
|
You must have the security privilege. However, if the target table being removed is a security audit gateway table (that is, was registered with DBMS=SXA), you must have the maintain_audit privilege.
|
|
|
The Remove Table statement locks the iirelation, iiattribute, iiqrytext, and iiregistrations catalogs.
|
|
|
|
|
|
The following example removes a security log registration:
remove table logfile_xyz;