Skip to content

privilegeAnalysis ​

Command: privilegeAnalysis
Category: Security
Status: Production Ready

Description ​

Analyze user or role privileges and generate least-privilege recommendations based on granted system, object, and role privileges.

Syntax ​

bash
hana-cli privilegeAnalysis [options]

Aliases ​

  • privanalysis
  • privanalyze

Command Diagram ​

Parameters ​

Positional Arguments ​

This command does not accept positional arguments.

Options ​

OptionAliasTypeDefaultDescription
--user-ustring-Target user to analyze.
--role-rstring-Target role to analyze.
--showUnused--unusedbooleanfalseInclude unused privileges in the output.
--suggest-sbooleantrueSuggest least-privilege recommendations.

Connection Parameters ​

OptionAliasTypeDefaultDescription
--admin-abooleanfalseConnect via admin (default-env-admin.json)
--conn-string-Connection filename to override default-env.json

Troubleshooting ​

OptionAliasTypeDefaultDescription
--disableVerbose--quietbooleanfalseDisable verbose output
--debug-dbooleanfalseEnable debug output

For the runtime-generated option list, run:

bash
hana-cli privilegeAnalysis --help

Examples ​

Basic Usage ​

bash
hana-cli privilegeAnalysis --user TESTUSER --suggest

Analyze TESTUSER privileges and include least-privilege suggestions.

  • roles - List roles and role metadata
  • users - List database users
  • grantChains - Visualize privilege inheritance chains

See the Commands Reference for other commands in this category.

See Also ​