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 theexecuteSync()
,execute()
, orprepare()
methods of TableAPI. - If
ExecuteOptions
doesn't specify a namespace, the default sysdefault namespace is used.
- If the
Using different namespaces in ExecuteOptions
allows executing the same
queries on separate but similar tables.