3 Namespace Management

A namespace defines a group of tables, within which all of the table names must be uniquely identified. This chapter describes namespaces and how to create and manage the namespaces in Oracle NoSQL Database.

Namespaces permit you to do table privilege management as a group operation. You can grant authorization permissions to a namespace to determine who can access both the namespace and the tables within it.

Namespaces permit tables with the same name to exist in your database store. To access such tables, you can use a fully qualified table name. A fully qualified table name is a table name preceded by its namespaces, followed with a colon (:), such as ns1:table1.

All tables are part of some namespace. There is a default Oracle NoSQL Database namespace, called sysdefault. All tables are assigned to the default sysdefault namespace, until or unless you create other namespaces, and create new tables within them. You cannot change an existing table's namespace. Tables in sysdefault namespace do not require a fully qualified name and can work with just the table name. For example, to access a table in sysdefault namespace, you can just specify table1 instead of sysdefault:table1.

Note:

In a store that was created new or was upgraded from a version prior to 18.3, all the tables will be part of sysdefault namespace.

This chapter contains the following topics:

• CREATE NAMESPACE Statement
• SHOW NAMESPACES Statement
• DROP NAMESPACE Statement
• Namespace Resolution
• Namespace Scoped Privileges
• Granting Authorization Access to Namespaces