Drop user schema/revoke to own schema
Just wondering whether it is possible to either drop an active users schema or at least revoke all privileges for a user on their own schema. Basically we have some users we do not want to be able to create objects, but are granted select privileges to a different schema where all data is maintained. Seems like a fairly simple thing but I cannot find any info on whether this is able to be done.
So, you can use "CREATE RESTRICTED USER XXX PASSWORD XXX".