Open gorros opened 4 years ago
Are you still having this issue with the latest version of the view? Any chance you can provide a repro?
I'm getting this too. I'm having trouble tracking down the edits to make to reverse default privileges that were set.
👍 same
I am trying to user
v_generate_user_grant_revoke_ddl
to change user ownership and drop user. But I am having issues withdefault acl
. Suggested step does not handle that caseselect regexp_replace(ddl,grantor,'<superuser>') from v_generate_user_grant_revoke_ddl where grantor='<username>' and ddltype='grant' and objtype <>'default acl' order by objseq,grantseq;
And get this error
owner of default privileges on new relations belonging to user