User Profiles  «Prev  Next»

Lesson 8

SQL*Plus utility Conclusion

The SQL*Plus utility is the standard way of offering interactive access to an Oracle database.
The product profile can be used to limit the way that your user community can use SQL*Plus.
Now that you have completed this module, you should be able to:
  1. Describe how the product profile works
  2. Limit access to a command
  3. Limit access for a role
  4. Use wildcards in defining product profiles
  5. Remove a restriction imposed by a product profile
  6. Report on product profiles.

With product profiles, it is much easier to give some or all of your users access to SQL*Plus without having to unleash its full power into their untrained hands. In the next module, you will learn how triggers can extend the functionality of your Oracle database.

W2ildcards Profile - Quiz
Click the Quiz link below to test your knowledge of some advanced product profile issues.
Wildcards Profile - Quiz