OraFAQ Forum: Forms » hide password in sql

Home » Developer & Programmer » Forms » hide password in sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

hide password in sql [message #673886]

Fri, 14 December 2018 04:16

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Dear |Friends,

I have made a table oracle sql .
CREATE TABLE USERS
(
USER_ID NUMBER(4, 0),
USER_NAME VARCHAR2(20 BYTE),
PASSWORD VARCHAR2(20 BYTE),
ROLE VARCHAR2(20 BYTE),
)

After that i made a user oracle forms.But problem is that every one can be check in oracle sql.
select user_id , user_name, password

Kindly guide me how i can hide user name and password.
and how to make a user forms.

Thanks and regards

Haider Ali

Report message to a moderator

Re: hide password in sql [message #673887 is a reply to message #673886]

Fri, 14 December 2018 04:19

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why do you need the table at all?
You log into forms as an oracle user, isn't that enough?

Report message to a moderator

Re: hide password in sql [message #673888 is a reply to message #673887]

Fri, 14 December 2018 04:24

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Sir,

I have to make a user authorize forms . So that user can use their forms.

Regards

Haider Ali

Report message to a moderator

Re: hide password in sql [message #673889 is a reply to message #673888]

Fri, 14 December 2018 04:26

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

That doesn't explain way you need a separate list of users to the actual oracle ones

Report message to a moderator

Previous Topic:	How to make search if i enter name it automatically search in the list like google
Next Topic:	I wanna to delete a single record from a data block based on table in database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 23:25:52 CDT 2023