Previous
Previous
 
Next
Next

Privileges Needed to Create and Delete Analytic Workspaces

Since an analytic workspace is physically stored as a table in an Oracle Database, you need SQL GRANT privileges to work with an analytic workspace. The privileges you need vary depending on whether the analytic workspace is in a schema that you own or in a schema that you do not own:

Note that Oracle Database does not turn on roles when you run a named PL/SQL procedure. In this case, the you must have the CREATE TABLE privilege directly.