文件名称:创建用户tea,stu,并给这两个用户resource,connect角色
文件大小:38KB
文件格式:PDF
更新时间:2024-01-04 10:27:08
c ce connect
创建用户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把自己拥