Be familiar with the authentication methods. Database accounts can be authenticated by the database (identified by password), by the operating system (identified externally), or by an enterprise security service (identified globally).
Know how to assign default and temporary tablespaces to users. Assign default and temporary tablespaces with either a CREATE USER or an ALTER USER statement.
Be able to identify and grant object, system, and role privileges. Know the difference between these types of privileges and when to use each type.
Know the differences between the WITH ADMIN OPTION and the WITH GRANT OPTION keywords. The ADMIN option applies to role or system privileges, but the GRANT option applies to object privileges ...