oracle命令行删除与创建用户的代码
来源:asp之家 时间:2009-03-02 10:54:00
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;
标签:oracle,命令行,删除,创建用户
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
encodeURIComponent用法UrlEncode与URLEncode.encode()
2009-05-11 12:40:00
解读iPhone平台的一些优秀设计思路
2010-06-24 21:53:00
![](https://img.aspxhome.com/file/UploadPic/20106/24/iphone_design_banner-88s.jpg)
带中英文翻译功能的收藏夹
2008-07-31 11:33:00
2个asp获取安全字符串的方法
2007-10-19 15:08:00
sqlserver 索引的一些总结
2012-08-21 11:03:31
![](https://img.aspxhome.com/file/UploadPic/20128/21/201282111731162s.png)
让大家看看Object标签的强大功能---多用途
2009-02-21 10:18:00
DOM_window对象属性之--clipboardData对象操作代码
2011-02-05 10:49:00
他们是如何不让我的Teleport和Webzip工作的?
2010-07-14 21:06:00
客户认同的就是好商品
2009-08-31 16:41:00
关于select元素的两个小问题
2008-12-25 13:41:00
再说淘宝的评价和信用机制
2008-07-10 12:43:00
解读MySQL的InnoDB引擎日志工作原理
2011-01-04 19:59:00
IE bug: 消失的绝对定位元素
2009-10-26 17:59:00
![](https://img.aspxhome.com/file/UploadPic/200910/26/demo1-38s.jpg)
oracle 多个字符替换实现
2009-10-23 17:50:00
CSS content, counter-increment 和 counter-reset详解[译]
2009-06-02 12:51:00
asp根据出生时间判断生肖
2008-03-24 19:49:00
根据表名和索引获取需要的列名的存储过程
2011-09-30 11:54:42
下一站:HandlerSocket!
2011-04-11 09:02:00
重温Javascript继承机制
2011-07-04 12:17:23
SQL Server数据库查询优化3种技巧
2008-10-17 10:10:00