Re: Restricting Database modifications via sqlplus

Giganews Newsgroups
Subject: Re: Restricting Database modifications via sqlplus
Posted by:  DA Morgan (damorg…@x.washington.edu)
Date: Mon, 03 Jan 2005

qazmlp wrote:

> [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?

I don't recall ever seeing that happen. Be sure the table is owned by
SYSTEM: Not by SYS.

--
Daniel A. Morgan
University of Washington
damorg…@x.washington.edu
(replace 'x' with 'u' to respond)

Replies

None

In response to

Restricting Database modifications via sqlplus posted by qazmlp on 3 Jan 2005