首页 / 数据库 / Oracle / Oracle命令创建用户并授权

创建用户：demo,密码：demopassword

create user demo identified by demopassword

授权连接及资源访问

grant create session,connect,resource to demo

授权表操作权限

grant select any table,update any table,drop any table to demo