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 |