Previous Next JavaScript must be enabled to correctly display this content

## Namespace Resolution

You can grant authorization permissions to a namespace to determine who can access both the namespace and the tables within it.

To resolve a table from a `table_name` that appears in an SQL statement, the following rules apply:

- - If the `table_name` contains a namespace name, no resolution is needed, because a qualified table name uniquely identifies a table.
  - If you don't specify a namespace name explicitly, the namespace used is the one contained in the `ExecuteOptions` instance that is given as input to the `executeSync()`, `execute()`, or `prepare()` methods of TableAPI.
  - If `ExecuteOptions` doesn't specify a namespace, the default sysdefault namespace is used.

Using different namespaces in `ExecuteOptions` allows executing the same queries on separate but similar tables.