cannot be dropped because some objects depend on it

GutoTrosla answered on November 18, 2023 Popularity 3/10 Helpfulness 10/10

answer cannot be dropped because some objects depend on it

Comment

REASSIGN OWNED BY systemuser TO <newuser>;
REVOKE ALL PRIVILEGES ON DATABASE workshop from systemuser;
DROP USER systemuser;

Popularity 3/10 Helpfulness 10/10 Language sql

Tags: sql

Link to this answer
Share Copy Link

Contributed on Nov 18 2023

GutoTrosla

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.