revoke UNLIMITED TABLESPACE

Be careful !! ORA-01536 after revoking DBA role from user

Many of the times we DBA get requests from AUDITORS  to apply security policies or DB hardening checklists on databases so that all schemas/users will be with least required privileges/roles. Now here we will discuss about one of the most critical – UNILIMITED TABLESPACE privilege – is the one which […]