{ASMディスクグループ}ディスクグループのアクセス制御を有効化

 

https://docs.oracle.com/cd/F19136_01/ostmg/asm-access-control-diskgroups.html#GUID-89BB888A-BA1C-4095-BB6D-C3BE142CB371

 

select group_number,name,value
from v$asm_attribute
where NAME like '%access%'
order by group_number,name;

alter diskgroup test2
   set attribute 'access_control.enabled'='TRUE';

alter diskgroup test2
   set attribute 'access_control.umask'='000';

 

SELECT * FROM V$ASM_USER;
SELECT * FROM V$ASM_USERGROUP;

ALTER DISKGROUP test2 ADD USERGROUP 'test_grp1';

※gridは自動で追加される

ALTER DISKGROUP test2 ADD USER 'oracle';

ALTER DISKGROUP test2 DROP USERGROUP 'test_grp1';

ALTER DISKGROUP test2 DROP USER 'oracle';
ALTER DISKGROUP test2 DROP USER 'grid';