Category SAP Hana User SYSTEM deaktivieren

SAP Hana User System deaktivieren


User mit den Rollen “USER ADMIN” erstellen

SYSTEM deaktiveren
ALTER USER SYSTEM DEACTIVATE USER NOW

SYSTEM wieder aktivieren
ALTER USER SYSTEM ACTIVATE USER NOW


#################################################
sudo su –
su – hb1adm
hdbsql
\c -i 12 -n sles287.comp.ds:31215 -d HB1 -u SYSTEM -p <PASSWORT>
\c -i 12 -n sles287.comp.ds:31215 -d HB1 -u USER -p <PASSWORT>

hdbsql -n sles287.comp.ds:31215 -i 12 -d HB1 -u USER -p <PASSWORT> “SELECT * FROM “PUBLIC”.”EFFECTIVE_PRIVILEGES” where USER_NAME = ‘SYSTEM’;” | column -t | more

hdbsql -n sles287.comp.ds:31215 -i 12 -d HB1 -o test2.txt -u USER -p PASSWORD “SELECT * FROM “PUBLIC”.”EFFECTIVE_PRIVILEGES” where USER_NAME = ‘SYSTEM’;”


#Show Granted Role
SELECT * FROM “PUBLIC”.”EFFECTIVE_ROLES” where USER_NAME = ‘SYSTEM’;
SELE...

Read More