Which system privilege do you need to redistribute tables across the hosts in a scale-out system?
Which system privilege do you need to redistribute tables across the hosts in a scale-out system?
To redistribute tables across the hosts in a scale-out system, you need the RESOURCE ADMIN privilege. This privilege allows for the management of resources within the system, including the redistribution of tables. Managing resources, such as data distribution, is a critical operation that falls under RESOURCE ADMIN privileges.
HA201-SAP HANA 2.0 SPS06 - High Availability and Disaster Tolerance Administration To redistribute tables across the hosts in your system, you must have the system privilege RESOURCE ADMIN and at least the object privilege ALTER for all schemas involved. As redistributing data is a critical operation, it is also recommended that you have saved the current distribution so you can restore it if necessary.
B. ALTER DISTRIBUTION privilege is required, and it falls under the RESOURCE ADMIN system privilege.