oracle命令行删除与建立用户的代码_长宁区硬盘数
日期:2014-06-07 / 人气: / 来源:网络
相关操作代码如下:
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;
新Orcas语言特性-查询句法
【原文地址】New
Oracle,存储过程
作者:管理员
推荐内容 Recommended
- 江苏飞浩信息科技期待您的加入07-20
- 江苏飞浩科技欢迎您07-19
相关内容 Related
- 江苏飞浩信息科技期待您的加入07-20
- 江苏飞浩科技欢迎您07-19