Database Reference
In-Depth Information
23
Security
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?
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 Ora-
cle SQL programmers, especially in isolated development environments.
This chapter covers general Oracle Database 10
g
23.1
Users
You might have been practicing throughout reading this topic on a database
using the MUSIC schema. You know, of course, that you have been logging
into Oracle Database as an Oracle user. The user has a name, such as
MUSIC, and a password. The MUSIC user has authority to create tables in
its own schema. The MUSIC user was created by another user, who has
authority to create users and assign them the capabilities they need, such as
the ability to create a table.
