| A | B |
| Schema | a collection of objects, such as tables, views, and sequences |
| System privileges | the right to access the database and its objects |
| Role | a named group of related privileges that can be granted to the user |
| Database link | a pointer that defines a one-way communication path from one Oracle database to another Oracle database |
| PUBLIC privilege | The right of an owner of a table to grant access to all Users |
| Object privileges | the right to manipulate the content of the objects in the database |
| System security | covers access and use of the database at the system level |
| Privilege | the right to execute particular SQL statements |
| CREATE SESSION privilege | the right to connect to the database |
| Object security | covers access and use of the database objects and the actions users can have on those objects |
| WITH GRANT OPTION | allows the grantee to grant the object privileges to other users and roles |
| GRANT privilege | the right to grant specific system privileges to a user |
| REGULAR EXPRESSIONS | Used to execute a SQL wildcard search |
| Subexpressions | Used when searching for a specific sequence and the first offset position is needed |