create role appdev identified by 1234; -- 创建role
grant dba to appdev; -- 给角色授权
set role appdev identified by password;  -- 修改role密码
grant appdev to guanyu with admin option; -- 给某个用户添加appdev权限

drop role appdev; -- 删除role