9.7. Sharing Code
You create an Oracle account with a username, password, and basic roles that allow that user to create tables and procedures. You add a new user named BLAKE to the database with the following:
CREATE USER BLAKE IDENTIFIED BY BLAKE DEFAULT TABLESPACE STUDENT_DATA TEMPORARY TABLESPACE TEMP; GRANT CONNECT, RESOURCE TO BLAKE;
From this point forward, BLAKE can create tables and stored procedures. Another user SCOTT is also creating procedures. By default, BLAKE cannot see SCOTT'S objects and SCOTT cannot see BLAKE'S objects.
Sharing of objects is done on a per-object bases. BLAKE can grant table and package access to SCOTT on an as-needed basis. BLAKE has a package that provides selected payroll information. The PAYROLL package ...