In this chapter:

  • How do you create a user?

  • How do you change a user, and what can be changed?

  • What are privileges?

  • How are privileges classified?

  • How do roles group privileges?

  • When are roles and privileges used?

This chapter covers general Oracle Database 10g access privilege and security issues. You will find out how to share your table data with others using privileges and roles. You will also learn the DBA tasks of creating new users and giving them authority to perform various kinds of work within the database. Creating and managing users and privileges are often DBA tasks. As a result, many DBA-type options are omitted from this chapter. On the other hand, simple security and access skills are very useful for Oracle SQL programmers, ...

Get Oracle SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.