Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Restrict ALTER DATABASE command in Oracle

Raj KushawahaDec 20 2019 — edited Jan 17 2020

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

Comments

Ashish Dave-Oracle
either there is Synchronization issue or
element which was there at time of recording is not there while playback ..could be defect
or name or id of elemet changed
1 person found this helpful
647280
You should create a better custom dynamic variable to identify this element. Referencing a element by Index is not recommended or reliable. A recorded Index of 41 for the element inside form QUERYTEXTCOMPONENTS indicates that there are a lot of elements inside that recorded form, and that there is probably some dynamic nature to the page.

You should change the match to be i.e. formelement[INPUT](name="something" | id = "something")
1 person found this helpful
1 - 2

Post Details

Added on Dec 20 2019
#database-security, #database-security-general
5 comments
652 views