大家好,又见面了,我是你们的朋友全栈君。
--创建用户 testuser 密码 123456
create user testuser identified by 123456;
grant resource,connect to testuser ;
grant select any dictionary to testuser ;
grant select any sequence to testuser ;
grant select any table to testuser ;
grant create any table,alter any table,drop any table,create any view to testuser ;
grant select any table,update any table to testuser ;
grant insert any table,delete any table to testuser ;
grant create any table,alter any table,drop any table to testuser ;
grant create any trigger,alter any trigger,drop any trigger to testuser ;
grant create any procedure,alter any procedure,drop any procedure to testuser ;
grant create any sequence,alter any sequence,drop any sequence to testuser ;
grant create any synonym,drop any synonym to testuser ;
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/144275.html原文链接:https://javaforall.cn