Oracle Database

Oracle Database, the related services (cloud) and various options in the database.

Granting privileges on all or multiple objects to user/role

by

Granting privileges on all or multiple objects to user/role Question:I need to grant SELECT, UPDATE privilege on all tables owned by schema XXVMX to users MSUBBU, SMARTIN. Is there a command in Oracle to grant a privilege on all objects in schema to user? Answer:No such privilege in Oracle. You will have to write a … Read more

Query – Tablespace Max Size

by

I sometimes see concerned emails from developers that they are running out of space in tablespace and the DBA need to do something immediately. The DBA will start wondering we have monitoring in place, then how come it did not catch an out of space situation, but a user/developer did… For you developer/user, if you … Read more