|
Oracle 10g Free Training - Creating Roles and Granting Privileges |
|
Page 2 of 2
4. The Roles page would display up as shown in figure 5 below. Click on the CREATE button to create a role.
Figure 5. Create Role tab
5. The Create Role window would display the window as shown in figure 6 below.
Figure 6. Create Role Window
After entering the relevant fields in the window you can check the sql query by clicking on the button "Show SQL" which will be executed by em to create the role.
Figure 7. Show Sql Window
Return back to previous window by clicking back button and click OK Button to create the role and following window will appear .
Figure 8. Role Created Window
This shows that role ‘DBA_ROLE’ has been created in the database.
Trackback(0)
|
TrackBack URI for this entry
Subscribe to this comment's feed
Show/Hide comments
Show/Hide comment form