oracle命令行删除与创建用户的代码
2019/6/30 21:21:40
本文主要是介绍oracle命令行删除与创建用户的代码,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
oracle命令行删除用户:
connect / as sysdba;
shutdown abort;
startup;
drop user user1 cascade;
exit
oracle命令行创建用户:
create user user1
identified by values 'fa091872a2cc669c'
default tablespace user1
temporary tablespace temp
profile default
account unlock;
-- 4 roles for user1
grant recovery_catalog_owner to user1 with admin option;
grant resource to user1 with admin option;
grant dba to user1 with admin option;
grant connect to user1 with admin option;
alter user user1 default role all;
-- 3 system privileges for user1
grant select any dictionary to user1 with admin option;
grant unlimited tablespace to user1 with admin option;
grant alter any procedure to user1 with admin option;
复制代码 代码如下:
connect / as sysdba;
shutdown abort;
startup;
drop user user1 cascade;
exit
oracle命令行创建用户:
复制代码 代码如下:
create user user1
identified by values 'fa091872a2cc669c'
default tablespace user1
temporary tablespace temp
profile default
account unlock;
-- 4 roles for user1
grant recovery_catalog_owner to user1 with admin option;
grant resource to user1 with admin option;
grant dba to user1 with admin option;
grant connect to user1 with admin option;
alter user user1 default role all;
-- 3 system privileges for user1
grant select any dictionary to user1 with admin option;
grant unlimited tablespace to user1 with admin option;
grant alter any procedure to user1 with admin option;
这篇关于oracle命令行删除与创建用户的代码的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!