Revoking Public Permissions in PostgreSQL ArcSDE
While banging my head on how to grant access to a referenced mosaic dataset , I did something out of frustration that I normally would not do–I granted ‘public’ access to some data.
Then, after figuring out the problem, I went to revoke public access using ArcCatalog and received this error message:
Error 999999: Error executing function.
The Object being referenced does not exist [ERROR: role ‘public’ does not exist::SQL state: 42704]