对oracle用户进行资源限制
摘要:
select username,profile, INITIAL_RSRC_CONSUMER_GROUP from dba_users;修改用户的配置文件alter user report profile LIMITUSER;alter profile limituser limit CONNECT_TIME UNLIMITED;---修改用户的资源消费者组execute dbms_resource_manager_privs.grant_switch_consumer_group('REPORT','DEFAULT_CONSUMER_GROUP',FALSE) 阅读全文
posted @ 2012-05-07 18:06 IT老友 阅读(2800) 评论(0) 推荐(0) 编辑