X

Welcome to All Things Warehouse Builder

SQL for workspace enablement

Jean-Pierre Dijcks
Master Product Manager

As a quick follow up on my post on accessing SQL views in 11g OWB, here is a simple one if you are in SQL Dev or SQL Plus:

begin

owbsys.wb_workspace_management.set_workspace('workspacename', 'workspaceowner');

owbsys.start_enable_owb_roles;

end;

Replace the italics for workspacename and workspaceowner with the name of your workspace and the name of the owner (or user of) the workspace.

Now you can do what you need in direct access tools like SQL Plus...

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.