Home » Developer & Programmer » Forms » hide password in sql
hide password in sql [message #673886] Fri, 14 December 2018 04:16 Go to next message
haider_1pk
Messages: 109
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
Re: hide password in sql [message #673887 is a reply to message #673886] Fri, 14 December 2018 04:19 Go to previous messageGo to next message
cookiemonster
Messages: 13864
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?
Re: hide password in sql [message #673888 is a reply to message #673887] Fri, 14 December 2018 04:24 Go to previous messageGo to next message
haider_1pk
Messages: 109
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
Re: hide password in sql [message #673889 is a reply to message #673888] Fri, 14 December 2018 04:26 Go to previous message
cookiemonster
Messages: 13864
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
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:
  


Current Time: Sun Mar 29 02:06:47 CDT 2020