The PUBLIC Role
All users of the database have the PUBLIC
role. In a newly created TimesTen database, by default PUBLIC
has SELECT
and EXECUTE
privileges on various system tables and views and PL/SQL functions, procedures and packages. You can see the list of objects by using this query:
SELECT table_name, privilege FROM sys.dba_tab_privs WHERE grantee='PUBLIC';
Privileges that are granted to PUBLIC
as part of database creation cannot be revoked. To see a list of these privileges, use this query:
SELECT table_name, privilege FROM sys.dba_tab_privs WHERE grantor='SYS';