创建用户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
创建用户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