2 Authorization in TimesTen

One aspect of TimesTen access control is the use of permissions, or privileges, to authorize or limit access to database objects such as tables or views.

This chapter discusses TimesTen features for authorization, covering these topics:

• Privileges Overview

• System Privileges

• Overview of Privileges to Create, Alter, or Drop Objects

• Privileges for SQL Objects

• Privileges for PL/SQL Objects

• Privileges for Cache Groups

• User Privilege Views

Note:

• For a list of object privileges, see Privileges in Oracle TimesTen In-Memory Database SQL Reference.

• For TimesTen SQL statements discussed in this chapter, syntax and required privileges are documented in SQL Statements in Oracle TimesTen In-Memory Database SQL Reference.

• Examples in this chapter use the TimesTen ttIsql utility, indicated by the Command> prompt.