use product_user_profile table.
This is an example of how to insert a row into the PUP table to restrict
the user HR from using the SELECT statement:
1. Log in as SYSTEM with the command
SQLPLUS SYSTEM/MANAGER

2. Insert a row into the PUP table with the command:
INSERT INTO PRODUCT_USER_PROFILE
VALUES ('SQL*PLUS', 'HR', 'SELECT', NULL, NULL, 'DISABLED', NULL,
NULL);

3. Connect as HR/HR and try to SELECT something:
CONNECT HR/HR;
SELECT * FROM EMP_DETAILS_VIEW;
This command causes the following error message:
SP2-0544: INVALID COMMAND: SELECT

4. To delete this row and remove the restriction from the user HR,
CONNECT again as SYSTEM and enter:
DELETE FROM PRODUCT_USER_PROFILE WHERE USERID = 'HR';


Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



"K. Suresh"
<k.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
oup.com> cc:
Subject: Disabling SQLPLUS Command
01/30/2004 12:34
PM
Please respond to
"K. Suresh"






Hi all,

is there any way by which we can disable a particular sqlplus command for
an user...

suresh





Oracle LazyDBA home page