oracle 创建用户命令修改用户密码命令以及授权

最新推荐文章于 2024-08-02 16:50:13 发布

漏气的可乐

最新推荐文章于 2024-08-02 16:50:13 发布

阅读量786

点赞数

分类专栏：数据库文章标签： orcale 创建orcale用户给orcale用户授权

本文链接：https://blog.csdn.net/weixin_43841301/article/details/102842618

版权

数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

创建用户 cb密码 root

create user cb identified by root;
grant resource,connect to cb ;
grant select any dictionary to cb ;
grant select any sequence to cb ;
grant select any table to cb ;
grant create any table,alter any table,drop any table,create any view to cb ;
grant select any table,update any table to cb ;
grant insert any table,delete any table to cb ;
grant create any table,alter any table,drop any table to cb ;
grant create any trigger,alter any trigger,drop any trigger to cb ;
grant create any procedure,alter any procedure,drop any procedure to cb ;
grant create any sequence,alter any sequence,drop any sequence to cb ;
grant create any synonym,drop any synonym to cb ;