流年飘飘hawking8987.blog.chinaunix.net
hawking8987
全部博文(213)
2007年(213)
FunBSD
dragonfl
interfac
hxl
cqxfy
ambrasew
浪花小雨
yqfntx
hooca
zhengbao
分类: Oracle
2007-10-11 11:14:46
CREATE ROLE "TESTROLE" IDENTIFIED BY "hawkingwan";GRANT ALTER ANY INDEX TO "TESTROLE" WITH ADMIN OPTIONGRANT SELECT ANY TABLE TO "TESTROLE" WITH ADMIN OPTIONGRANT "CONNECT" TO "TESTROLE";GRANT "DBA" TO "TESTROLE";BEGIN dbms_resource_manager_privs.grant_switch_consumer_group( grantee_name => 'TESTROLE', consumer_group => 'DEFAULT_CONSUMER_GROUP', grant_option => FALSE );END;
上一篇:使用智能优化器提高Oracle性能极限
下一篇:ORACLE概要文件管理
登录 注册