创建用户tea,stu,并给这两个用户resource,connect角色 conn system/orcl; create user tea identified by tea; create user stu identified by stu; grant resource to tea; grant connect to tea; grant resource to stu; grant connect to stu; 使用scott用户把对emp表的select权限给tea conn scott/tiger; grant select on emp to tea; 将让tea把自己拥