access oracle 9i only from Application and not thru SQLprompt [message #74165] |
Sat, 25 September 2004 03:11 |
Mahesh P
Messages: 69 Registered: September 2004
|
Member |
|
|
hai buddies,
i want to restrict my DataBase(Oracle 9i) only to my application(JSP).Application users enter into their schema by using the username and password given in application interface. there is possibility that using the same username and password they can enter into sqlprompt which i have to restrict this.the schema must access only from the application but not from sqlprompt. how do u do this?
thanks alot
regards,
MaheshP
|
|
|
Re: access oracle 9i only from Application and not thru SQLprompt [message #74166 is a reply to message #74165] |
Sat, 25 September 2004 07:10 |
rammohan
Messages: 13 Registered: March 2002
|
Junior Member |
|
|
yes. thro a table product_user_profile in system USER.
you insert in this table
insert into product_user_profile
(product,userid,attribute,char_value)
values('SQL*PLUS',USERNAME,SELECT,'DISABLED')
IF U WANT TO RESTRICT THE USER FROM USING THE SQLPROMPT
U HAVE TO INSERT 4 RECORDS PER USER I.E. INSERT / SELECT / UPDATE / DELETE.
BYE
|
|
|