Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Security on tables

If i am having  3 tables out of which i want to apply security on 2 tables then how i apply security on tables?

yojas

5 Replies
Not applicable
Author

Hi,

in Qlikview security is applied on document level and field level/data level.

for Document level if that document is needed to be seen from server than NTFS/DMS level authorization is also required.

Data/field level security is implemented using section access.

where you can use OMIT field to omit the fields at all or if you want only some of the data from that field to be shown for a user than it needs to linked to that user name or id somewhow.

You can not secure just a table for a particular user but you can use OMIT in section access which omits a field and if you use OMIT for all the fields in 3rd table then 3rd table will not be loaded for that user. but if you have some common field then rather then using OMIT for that field you can use data level security so, you can hide the values in that field which come from table3.

To read about section access in detail go to this link/document which will be a good starting point for section access.

http://community.qlik.com/docs/DOC-1853

Hope this helps.

...

Ashutosh

Not applicable
Author

Hi  Ashutosh,

Can you tel me when we use ODBC  connection and When we use OLEDB?

yojas

Not applicable
Author

Not applicable
Author

the links you provided shows me that OLEDB is better than ODBC but i want to know advantages of ODBC....because if OLEDB is so benificial then why people go for ODBC connection???? there must be some advantage of it .....i want to know that..... can you please help me regarding that.......

yojas

Not applicable
Author

Dear Yojas,

in some cases OLEDB can be better than ODBC because

     It is a newer technology then ODBC and in most cases gives better performance also it is easier to set up than ODBC.

    but why ODBC is widely used is because of its being Open standard while OLEDB is developed by Microsoft.

     ODBC can be used on unix systems also but I believe OLEDB can not be used.  

     ODBC has been there for quite a long and is widely used and supported.

and one more reason is that ODBC being a standard its drivers are easily available while for some systems it may be difficult to find OLEDB drivers.

So, if OLEDB drivers are available then OLEDB can also be used there is no harm in using OLEDB.

one very good explanation is on

ftp://ftp.sas.com/techsup/download/v8papers/odbcdb.pdf

some more links on oledb

http://stackoverflow.com/questions/1178243/what-is-the-difference-between-odbc-and-oledb

http://stackoverflow.com/questions/271504/oledb-v-s-odbc

..

Ashutosh