创建用户
语法:
create user 用户名 identified by 密码
ps:
create user ythuser identified by ythuser
create user ythbus identified by ythbus
给用户授权,可以是多个一起
语法
grant 角色名(可以多个) to 用户名(可以多个)
ps:
grant connect,resource,dba to ythuser,ythbus
语法:
create user 用户名 identified by 密码
ps:
create user ythuser identified by ythuser
create user ythbus identified by ythbus
语法
grant 角色名(可以多个) to 用户名(可以多个)
ps:
grant connect,resource,dba to ythuser,ythbus