Re: ASM privileges

Posted by ErmanArslansOracleBlog on Jul 30, 2018; 2:20pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ASM-privileges-tp6503p6511.html

OSDBA of RDBMS can do -sqlplus "/as sysdba"-  on DB.
So it can do anything that can be done using sysdba privilege.

The things can be done with OSDBA of ASM changes according to your release.
For ex: Members of the OSDBA group formerly were granted SYSASM privilege on Oracle ASM instances, including mounting and dismounting disk groups.
However, in 11gR2 this grant was removed. (Actually this grant is revoked if different operating system groups are designated as the OSDBA and OSASM groups. If the same group is used for both OSDBA and OSASM, then the privileges are retained.)


Ref Oracle:

Members of the ASM Database Administrator group (OSDBA for ASM) are granted read and write access to files managed by Oracle ASM. The Oracle Grid Infrastructure installation owner and all Oracle Database software owners must be a member of this group, and all users with OSDBA membership on databases that have access to the files managed by Oracle ASM must be members of the OSDBA group for ASM.

In Oracle 12.2, this group grants access for the database to connect to Oracle ASM.

So, this subject is a little tricky and the information is a little bit confusing, as you see.

Please tell me what your purpose is.. So that I can suggest you something.