CONNECT : |
Gives a user the ability to create a session and create basic database objects |
DBA : |
Gives the user all system privileges, each with WITH ADMIN OPTION , which is explained in a later lesson |
CONNECT
role is usually granted to all new database users, while the DBA role must be granted very selectively because of its power.