Restricting Database modifications via sqlplus

Giganews Newsgroups
Subject: Restricting Database modifications via sqlplus
Posted by:  qazmlp (qazmlp12…@rediffmail.com)
Date: 3 Jan 2005

[Follow-up does not work properly from 'google' groups at this moment.
Hence, this may look like a new thread. But, this is just a
continuouation to previous thread with the same subject)

That helped!
After inserting corresponding records in product_user_profile,
SQL*Plus started reporting errors,whenever user tries to invoke
prevented commands. That was fine as I wanted. Meanwhile, I noticed
the following related to entries in product_user_profile tables.

Whenever I(using sysdba login) try to insert a record in
product_user_profile, the row is inserted successfully. But, when I
try to display the records from product_user_profile tables(even after
commit operation), 'no rows selected' message is reported. Why does
such a strange behaviour for product_user_profile table? Is this for
security reasons? Could anybody elaborate on this?

Replies