How To Create An SYSASM User On Release 11g
来源:互联网 发布:青铜5 知乎 编辑:程序博客网 时间:2024/06/07 10:50
On release 11g and onwards, you need to create an ASM user and grant the SYSASM role. The purpose of the SYSASM role is to provide a level of separation between the RDBMS & ASM credentials.
The SYSASM role, which has full capability on the ASM instance, is authenticated through the OSASM user group, similar to the SYSDBA roles, which is authenticated through OSDBA.
1) The following example shows how to connect as SYSASM and configure a new user for SYSASM role:
+ASM:oracle> export ORACLE_SID=+ASM
+ASM:oracle>sqlplus "/as sysasm"
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 1 15:44:00 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create user ASMUSER identified by oracle;
User created.
SQL> grant SYSASM, SYSOPER to ASMUSER;
Grant succeeded.
SQL> exit
2) Then connect as ASMUSER:
+ASM:oracle> export ORACLE_SID=+ASM
+ASM:oracle>sqlplus "ASMUSER/oracle as sysasm"
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 1 15:45:26 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPE SYSASM
------------------------------ ------ ------ ------
SYS TRUE TRUE TRUE
ASMUSER FALSE TRUE TRUE
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
- How To Create An SYSASM User On Release 11g
- How to create ftp user on Linux
- How to manually release Insufficient Funds Hold on An Invoice?
- How To Resize An ASM Disk On Release 10.2.0.X
- How to create a new user and grant permissions on MySql
- How to create a user in PostgreSQL
- How to create a remote desktop user
- How to create an IPA on Xcode 4.3.2(打包成ipa)
- how to create an ssl certificate on nginx for ubuntu14.04
- How to create an SMTP Trace Listener
- How to create an RPM package
- How to Create an Report Style
- How to create an RMI system
- How To Create an IE-Only Stylesheet
- How to allow a user to click on TextBlocks which return an integer ID in the click handler
- User Xcode and GCC How to create a C programe
- How to create Dynamics CRM Online User License
- How to create user defined properties in Maven
- 让Basicexcel完美支持中文且不改变原有接口
- P2P---UDP穿透NAT的原理与实现
- 又见优先级
- 链表学习--双向链表实现
- 链表学习--双向链表实现
- How To Create An SYSASM User On Release 11g
- p2p---开源项目收集
- 二叉树
- 类的说明符与方法的说明符
- Fedora 安装Broadcom 43XX网卡驱动
- 包的相关知识
- instanceof
- super
- final关键字和静态方法static