This privilege authorizes the creation and deletion of roles using the CREATE ROLE and DROP ROLE commands. It also authorizes many of the commands available in the Management Console. This privilege authorizes commands concerning system resources, for example ALTER SYSTEM RECLAIM DATAVOLUME and ALTER SYSTEM RESET MONITORING VIEW. Note that beside this privilege the user requires the INSERT privilege on the target tables to be imported.Īuthorizes the SET SYSTEM LICENSE command install a new license.Īuthorizes the ALTER SYSTEM LOGGING commands to enable or disable the log flush mechanism.Īuthorizes the ALTER SYSTEM commands for EVENTs.Īuthorizes the ALTER SYSTEM commands concerning SQL PLAN CACHE and ALTER SYSTEM UPDATE STATISTICS commands, which influence the behavior of the query optimizer. It also enables execution of any Data Definition Language (DDL) commands in the SAP HANA databaseĪ user having this privilege cannot select or change data stored tables for which they do not have access privileges, but they can drop tables or modify table definitions.Īuthorizes export activity in the database via the EXPORT TABLE command.Note that beside this privilege the user requires the SELECT privilege on the source tables to be exported.Īuthorizes the import activity in the database using the IMPORT commands. Only the owner of an Analytical Privilege can further grant or revoke that privilege to other users or roles.Īuthorizes reading all data in the system and monitoring views.
Normally, the content of these views is filtered based on the privileges of the accessing user.Ĭontrols the creation of calculation scenarios and cubes (calculation database)Īuthorizes the creation of database schemas using the CREATE SCHEMA command.By default each user owns one schema, with this privilege the user is allowed to create additional schemas.Īuthorizes the creation of Structured Privileges (Analytical Privileges) System PrivilegeĬontrols the execution of the following auditing-related commands: CREATE AUDIT POLICY, DROP AUDIT POLICY and ALTER AUDIT POLICY and the changes of the auditing configuration.Īuthorizes the BACKUP command to define and initiate a backup process or to perform a recovery process.Īuthorizes users to have unfiltered read-only access to all system and monitoring views. The table below describes the supported system privileges. System privileges are used to restrict administrative tasks. | STRUCTUREDPRIVILEGE ADMIN | TRACE ADMIN | CREATE SCHEMA | CREATE STRUCTURED PRIVILEGE
0 kommentar(er)
