Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to implement Section Access
SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, EMPLOYEEID,OMIT
ADMIN, ADMIN
USER, UK, 4,ShipRegion
USER, USA, 1,Shipregion
USER, USA, 3,Shipregion
USER, USA, 2,Shipregion
];
SECTION APPLICATION;
OLEDB CONNECT TO [SQL Connection String]);
SQL SELECT [OrderID]
,[CustomerID]
,[OrderDate]
,[EmployeeID] AS EMPLOYEEID
,[RequiredDate]
,[ShippedDate]
,[ShipVia]
,[Freight]
,[ShipName]
,[ShipAddress]
,[ShipCity]
,[ShipRegion]
,[ShipPostalCode]
,UPPER([ShipCountry]) AS REGION
FROM Orders;
SQL SELECT EMPLOYEEID,EMPNAME FROM
FROM Employee;
For Employee table also it is applying Section Access. Is there any way that no Section Access is applied to Employee table (means to load complete Employee table irrespective of Section Access)
Hi,
we can't exclude table from section access. may be you can check this below advise
How to create data Island from sql server.
Also, can I use the data Island create in above step for view and without applying section access on data Island
Basically you need to add all possible values in the key field for the table and the table will not be reduced, schematically something like this:
SECTION ACCESS;
SectionAccessTable:
LOAD DISTINCT
'ADMIN' AS ACCESS,
'DIR\ADMIN' AS NTNAME,
COUNTRY,
'*' AS EMPID
FROM Invoices.qvd (qvd);
CONCATENATE (SectionAccessTable)
LOAD DISTINCT
'ADMIN' AS ACCESS,
'DIR\ADMIN' AS NTNAME,
'*' AS COUNTRY,
EMPID
FROM Employees.qvd (qvd);
CONCATENATE (SectionAccessTable)
LOAD * INLINE [
ACCESS, NTNAME, COUNTRY, EMPID
USER, DIR\USERSPAIN, SPAIN, *
USER, DIR\USERFRANCE, FRANCE, *
];
SECTION APPLICATION;
Invoices:
LOAD
INVOICEID,
COUNTRY,
AMOUNT
FROM Invoices.qvd (qvd);
Employees:
LOAD
EMPID,
EMPNAME
FROM Employees.qvd (qvd);