Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Summary

In this chapter, you learned that

  • A user is created using the CREATE USER statement.

  • System privileges allow you to perform certain actions within the database, such as executing DDL statements.

  • Object privileges allow you to perform certain actions on database objects, such as executing DML statements on tables.

  • You can avoid having to enter the schema name by creating a synonym for a table.

  • A role is a group of privileges that you can assign to a user or another role.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint