ALLOW_GROUP_ACCESS_TO_SGA

ALLOW_GROUP_ACCESS_TO_SGA controls group access to shared memory on UNIX platforms.

这个参数是12.2中出现的
Starting with Oracle Database 12c Release 2 (12.2.0.1), by default, permissions to read and write to the System Global Area (SGA) are limited to the Oracle software installation owner.
In previous releases, both the Oracle installation owner account and members of the OSDBA group had access to shared memory. 
The change in Oracle Database 12c Release 2 (12.2) to restrict access by default to the Oracle installation owner account provides greater security than previous configurations. 
However, this change may prevent DBAs who do not have access to the Oracle installation owner account from administering the database.

此参数默认为false,即只有oracle software install owner能读写SGA, 设置为true表示OSDBA的os group均有权限:
The Oracle Database initialization parameter ALLOW_GROUP_ACCESS_TO_SGA determines if the Oracle Database installation owner account (oracle in Oracle documentation examples) is the only user that can read and write to the database System Global Area (SGA), or if members of the OSDBA group can read the SGA. 
In Oracle Database 12c Release 2 (12.2), the default value for this parameter is FALSE, so that only the Oracle Database installation owner has read and write permissions to the SGA. Group access to the SGA is removed by default. This change affects all Linux and UNIX platforms.
If members of the OSDBA group require read access to the SGA, then you can change the initialization parameter ALLOW_GROUP_ACCESS_TO_SGA setting from FALSE to TRUE. Oracle strongly recommends that you accept the default permissions that limit access to the SGA to the oracle user account.


 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值