Execute the pupbld.sql script from
$ORACLE_HOME/sqlplus/admin/pupbld.sql, as user SYSTEM, to create the
product_user_profile table. Then you can insert into the table to disallow
specified users from executing certain sqlplus commands like UPDATE or
DELETE.


Syntax is

Insert into product_user_profile values
('SQL*Plus', '<USERID>', 'INSERT', NULL, NULL, 'DISABLED', NULL, NULL);

repeat for the different userid's and the other DML statements, excluding
'select'


Titus O. Olowokere
Oracle Certified DBA (OCP)
Atlanta, Georgia.
Tel.: 404-663-4091
[Email Address Removed] Original Message -----
From: "Oracle User" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, March 28, 2002 12:26 PM
Subject: Product User Profile table


|
|
| Hi
|
| Does any one have a clue about how to make an entry in the
| ProductUserProfile table? I want to restrict access to the users when they
| do an insert/update/delete from a particular table. They can use
| SQLPLus/Toad or any other tool.
|
| Any help appreciated.
|
| Thanks
| Raj
|
| _________________________________________________________________
| MSN Photos is the easiest way to share and print your photos:
| http://photos.msn.com/support/worldwide.aspx
|
|
| --------
| Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| Tell yer mates about http://www.farAwayJobs.com
| By using this list you agree to these
terms:http://www.lazydba.com/legal.html
|
|
Oracle LazyDBA home page