|
| Re: To view only limited record based on login user name |
| Iniciado por sivakrith, 29,ago. 2015 14:08 - 3 respuestas |
| |
| | | |
|
| |
Miembro registrado
10 mensajes |
|
| Publicado el 29,agosto 2015 - 14:08 |
Hello,
HFSQL 20
When a user login into HFSQL, he should be able to view only few records in a table, not all records.... Say a table consists of records from different countries, and a user from one country should be able to view only records concerning his country alone and of other countries records.
IS this possible to do in HFSQL ?
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,agosto 2015 - 16:40 |
Hi
it depends what you call "login into hfsql"...
If you are talking about the HF control center, then no, as this is a
tool for DB administrators, not regular users.
If you are talking about YOUR program, YOUR code, accessing data in a
HFSQL DB, then you can do whatever you want, just like in ANY other DB.
All that depends on your DB structure and your code logic.
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Already there: WXShowroom.com, WXReplication (open source)
Coming soon: WXEDM (open source)
More information on http://www.fabriceharari.com
On 8/29/2015 6:08 AM, Siva wrote:
Hello,
HFSQL 20
When a user login into HFSQL, he should be able to view only few records
in a table, not all records.... Say a table consists of records from
different countries, and a user from one country should be able to view
only records concerning his country alone and of other countries records.
IS this possible to do in HFSQL ?
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
10 mensajes |
|
| Publicado el 30,agosto 2015 - 07:07 |
Yes Fabrice, I know through a program we can make users view what we want. But I want to restrict the records, even from HF Control centre.
One solution could be to store in different tables, and restricting access to either table on user id. And to have a view to access all records, when required from Windev program. But I'm not sure about performance, when I access records through view. But how many tables, is another problem.
Not sure whether is problem is addressed in any RDBMS.... |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,agosto 2015 - 11:29 |
Hi again,
I think that you are looking at the problem the wrong way.
THe HFcontrol center should NEVER be left open to regular users.
If you want to give some user something with that kind of functionality,
it's very easy to do:
- one window
- one empy table
- one query (where you can limit what the user can see)
- and the instrcution buitdbrowsingtable
That's all
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Already there: WXShowroom.com, WXReplication (open source)
Coming soon: WXEDM (open source)
More information on http://www.fabriceharari.com
On 8/29/2015 11:07 PM, Siva wrote:
Yes Fabrice, I know through a program we can make users view what we
want. But I want to restrict the records, even from HF Control centre.
One solution could be to store in different tables, and restricting
access to either table on user id. And to have a view to access all
records, when required from Windev program. But I'm not sure about
performance, when I access records through view. But how many tables,
is another problem.
Not sure whether is problem is addressed in any RDBMS.... |
| |
| |
| | | |
|
| | | | |
| | |
|