| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> PUP table
I am trying to disable DML thru applications like TOAD, etc.. . The below
statements I
have inserted into the PUP table and still can SELECT as the userid in TOAD.
I have tested this
in SQL*PLUS and it worked. I could restrict SELECT from Joe in SQL*PLUS.
INSERT INTO PRODUCT_USER_PROFILE
VALUES ('TOAD', 'JOE', 'SELECT', NULL, NULL, 'DISABLED', NULL, NULL);
INSERT INTO PRODUCT_USER_PROFILE
VALUES ('TOAD.exe', 'JOE', 'SELECT', NULL, NULL, 'DISABLED', NULL,
NULL);
I have inserted these rows as the system user and committed. Why can I
still select thru TOAD?
thanks,
David Ehresmann
 |
 |