Q
Problem solve Get help with specific problems with your technologies, process and projects.

Stopping users from doing specific commands in SQL*Plus

Is there any way in Oracle to restrict the user from doing his normal operations like insert, delete, drop etc. at an application level (ie as soon as he types his query, it would restrict him in SQL*Plus without going to the database)?

Particularly if you want to stop users from doing specific commands in SQL*Plus, you can use the PRODUCT_USER_PROFILE table to build a security mechanism like you mention. See Appendix E of the SQL*Plus User's Guide and Reference for full details.

For More Information


Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close