Re: help: Pup security restricting does not seem to work

Mike,

I think that the first field has to be: SQL*Plus (note the lower case letters)

Phil

Mike F wrote:

> I followed oracle instructions on oracle sqlplus-security-disabling
> sql*plus,sql,and pl/sql commands
> SQL> insert into product_user_profile
> 2 values ('SQL*PLUS','USER1','SELECT',null,null,'DISABLE',null,null);
> 1 row created.
> SQL> commit;
> Commit complete.
> SQL> insert into product_user_profile
> 2 values ('SQL*PLUS','USER1','CONNECT',null,null,'DISABLE',null,null);
> 1 row created.
> SQL> commit;
> Commit complete.
> as system
>
> but I still can connect to USER1, and select on tables, what I did was
> wrong?
Received on Fri Feb 15 2002 - 12:00:27 CST