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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.