To access the Machine Learning Engine, users must be granted CONNECT THROUGH on the Machine Learning Engine service account (td_ffe_svc_acct). To delete these users, CONNECT THROUGH must be revoked first.
-
Check if your user has CONNECT THROUGH granted on td_ffe_svc_acct:
SELECT TrustUser, ProxyUser, ProxyUserType, GrantStatus, WithoutRole from dbc.connectrulesv;
TrustUser ProxyUser ProxyUserType GrantStatus WithoutRole --------------- -------------------- ------------- ----------- ----------- td_ffe_svc_acct hal P G Y td_ffe_svc_acct TDAP_ADMIN P G Y
-
Revoke CONNECT THROUGH from the user. For example:
REVOKE connect through td_ffe_svc_acct to permanent hal;
-
Delete all the tables for the user. For example:
delete user hal;
-
Remove the user from the database. For example:
drop user hal;