Roles Folder:

The Roles Folder, as it's name implies, gives you a view of all theroles created for the table, and a visual means to create new roles oralter existing roles. To get a quick look at how this folder works,let's create a test role that will have complete access to the customertable.

Select create rule from the folder, by right clicking onthe folder, and following the menu options. It should look like thefollowing:

This should now bring up the Data Object Editor window inthe center portion of your workspace. You will start in the Generaltab, and you will see that the Role name has been pre-filled, Let's change that to customer_role, so now you should seesomething like the following:

Let's now make sure we grant privileges to customer forthis role, to do this move down to the Privilege tab, clickon the table tab, and the click on the "Grant New Privileges"which looks like a yellow star. That will bring up the Gant NewPrivileges window. While it looks like you can just type a table namehere, you actually have to press the "browse" button and select the customer table fromthe browser. Once you do that you should see the window as shown below:

Go ahead and check all the boxes listed, and then check OK.

You will now be back in the main window. Just click on the Run DDL button, andthe customer_role role will be created

Now that you have a role in your Roles folder, let's look at what youcan actually do. You should see customer_role in the folder so rightclick on it, you should see the following:

As you can see you can do the following:

Alter the role

Drop the role

Generate the DDL for the role.

View Membership

The two not listed above (AnalyzeImpact, and CompareWith) are not actually used by roles. As I'm sure youhave noticed, you cannot add users to roles from the Role Folder, thatwill come with our discussion of the Users folder.

TheDatabase Explorer Window

Now that you have a workspace, and a connection established, it is timeto take a quick look around the options available to you in theDatabase Explorer window. By default this window is located in thelower left hand corner, and on start up looks like this:

As you can see this has a tool bar as well as the Connections folder.Let's take a quick look at the options you have on the tool bar.Traveling from Left to right, you have:

Collapse all:This allows you to quickly collapse all the folders you have opened inyour explorer, as shown in the above dialog.

Link:This allows you to link data in the explorer to an open editor.

SQL Scrapbook:This lets you open up a file that saves the SQL you aretesting.

Disconnect:Will disconnect any connection you have highlighter.

New Connection:Will take you to the connection tool, so you can add more connectionsand Databases to your Database Explorer.

SQL Editor:This lets you go straight to the SQL Editor Window.

ExportConnection: This lets you export an existing connection toXML. Makes it easy to deploy connections to multiple machines.

ImportConnection: Allows you to import the connection settingsfrom an XML file. So if, for instance, someone were to export theconnection settings for a development database, rather than having toget all the information to fill the connection string yourself, all youhave to do is import the connection.

Now let's open up our connections folder in this window. We willbe looking at the stores_demo database. So first we open theConnections folder, and then the stores_demo connection folder, andfinally the stores_demo database folder. And when the folders are open you will see something like the following:

As you can see, each connection tells you what type of instance you areconnecting too, in my case all of my instances are 11.10, thoughDeveloper Workbench reports them as 11.0. You can see thatthe Database folderhas three sub-folders. Those Folders are: