Database Administration (MOSC)

MOSC Banner

How can we restrict a user to modify particular columns of a table through sqlplus/sqlplusw or othe

edited Sep 18, 2013 5:46AM in Database Administration (MOSC) 7 commentsAnswered
Dear All,

I want to restrict modifications of specified columns of a table, through sqlplus/sqlplusw or sql developer or other utilities..i.e. they can be updated by my application only.

Whether such kind of restriction possible as a constraint ? if not what are the other ways to do the same?

so it won't allow any user to update such specified columns using other than my application..

Thanks

Ankit Shah

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center