5 Replies Latest reply on Jan 17, 2020 5:33 PM by pmdba

    Restrict ALTER DATABASE command in Oracle

    Raj Kushawaha

      Dear Community Experts,

       

      I have my oracle instances are running by oracle OS user and there are many other users in the database with dba role assigned to them.

       

      What I want is that only oracle OS users connected to the database can run the ALTER DATABASE or ALTER TABLESPACE commands and other third party user connecting from remote systems or connected to database using different OS user accounts can't run the ALTER DATABASE and ALTER TABLESPACE  commands.

       

      Please help me understand how can I achieve this database security goals.

       

      Regards,

      -Raj