小白求助一个初级的问题

Question

connect和resource权限各是什么含义啊。
是不是所有新建用户都有个默认角色，这个默认角色都是可以建表的？

Answer 1

[TEST@myoracle] SQL>SELECT *
  2    FROM ROLE_SYS_PRIVS t
  3   WHERE t.role IN ('CONNECT', 'RESOURCE')
  4   ORDER BY ROLE;ROLE                           PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
CONNECT                        CREATE SESSION                           NO
RESOURCE                       CREATE CLUSTER                           NO
RESOURCE                       CREATE INDEXTYPE                         NO
RESOURCE                       CREATE OPERATOR                          NO
RESOURCE                       CREATE PROCEDURE                         NO
RESOURCE                       CREATE SEQUENCE                          NO
RESOURCE                       CREATE TABLE                             NO
RESOURCE                       CREATE TRIGGER                           NO
RESOURCE                       CREATE TYPE                              NO已选择9行。/