By default a workspace has got one schema where it uses the objects from. You can add more schemas to a workspace. This recipe tells you how to do that.
There are two ways to add a schema to a workspace:
We will now continue as the instance administrator so log on to the internal workspace as administrator.
The internal administrator will now get a message when he or she logs on to the internal workspace.
You can add one or more schemas to a workspace. When you create an application, you can choose which schema you will use for the application. But you can of course reference to tables from another schema if your schema is granted the necessary privileges. So, a workspace can access more schemas but an application is limited to only one schema. You can see which parsing schema an application uses. Log on to the internal workspace and go to Manage workspaces and click the Parsing schemas link in the manage applications section.
You can also control which schemas a user can access in SQL workshop. Log on as the workspace administrator and go to administration manage users and groups. Edit a user by clicking on the edit pencil. You will see that in the account privileges section there is an item called accessible schemas, where you can enter the names of the schemas where the user has access to in SQL workshop. This item is not available when you edit a user via the internal workspace.
3.135.183.138