Download IMDB Cache User's Guide

Configuring the Oracle database to cache data in TimesTen
Table 3–1 (Cont.) Oracle Database and TimesTen user privileges required for cache operations
Cache operation
ALTER CACHE GROUP SET
AUTOREFRESH STATE ON
Privileges required for Oracle
Database cache administration
user1
■
Privileges required for TimesTen
cache manager user2
ALTER ANY CACHE GROUP10
CREATE SESSION
6,9
■
SELECT ON table_name
■
RESOURCE4,9
■
CREATE ANY TRIGGER4,9
ALTER CACHE GROUP SET
AUTOREFRESH STATE OFF
CREATE SESSION
ALTER ANY CACHE GROUP10
ALTER CACHE GROUP SET
AUTOREFRESH MODE FULL
CREATE SESSION
ALTER ANY CACHE GROUP10
ALTER CACHE GROUP SET
AUTOREFRESH MODE INCREMENTAL
ALTER CACHE GROUP SET
AUTOREFRESH INTERVAL
LOAD CACHE GROUP
REFRESH CACHE GROUP
FLUSH CACHE GROUP
CREATE SESSION
■
SELECT ON table_name6
■
RESOURCE4
■
CREATE ANY TRIGGER4
■
CREATE SESSION
■
SELECT ON table_name
■
CREATE SESSION
■
SELECT ON table_name
■
CREATE SESSION
■
SELECT ON table_name
■
CREATE SESSION
LOAD {ANY CACHE GROUP | ON
cache_group_name)10
6
REFRESH {ANY CACHE GROUP | ON
cache_group_name)10
6
FLUSH {ANY CACHE GROUP | ON
cache_group_name)10
■
INSERT ON table_name6
DROP CACHE GROUP
CREATE SESSION
Asynchronous writethrough when
the CacheAWTMethod connection
attribute is set to 1
6
UPDATE ON table_name
None
Asynchronous writethrough
ALTER ANY CACHE GROUP10
6,11
■
UNLOAD CACHE GROUP
Synchronous writethrough or
propagate
ALTER ANY CACHE GROUP10
■
UNLOAD {ANY CACHE GROUP | ON
cache_group_name)10
■
DROP ANY CACHE GROUP10
■
DROP ANY TABLE12
■
CREATE SESSION
■
INSERT ON table_name14
■
INSERT ON table_name6,13
■
UPDATE ON table_name14
■
UPDATE ON table_name6,13
■
DELETE ON table_name14
■
DELETE ON table_name6,13
■
CREATE SESSION
■
INSERT ON table_name14
■
UPDATE ON table_name14
■
DELETE ON table_name14
6
■
INSERT ON table_name
■
UPDATE ON table_name6
■
DELETE ON table_name6
No additional privileges
CREATE PROCEDURE
Note: This privilege is an addition to
the privileges needed for any
asynchronous writethrough cache
group.
Setting Up a Caching Infrastructure
3-7