section access using database connection

124psu — Sat, 16 Nov 2024 03:24:16 GMT

Hello,

I am able to get the section access up and running using the inline method. I want to transition this over to a database method so that way I can control the users through the database instead going into the script and adding/deleting rows from the inline.

Here is my working script for the "IN LINE" method:

SECTION ACCESS;

LOAD * INLINE [

upper("access") as ACCESS,
upper("userid") as USERID,
upper("accessid") as ACCESSID
];

LOAD * INLINE [

ACCESS, USERID, ACCESSID
ADMIN, INTERNAL\SA_SCHEDULER, *,
ADMIN, ABC\124psu, *,
USER, ABC\124psu, M,
USER, ABC\124psu, A,

];

SECTION APPLICATION;

LOAD * INLINE [

ACCESSID, Organization

M, Marketing
A, Accounting
IT, IT
];

In this case, for testing purposes, I will only see data for Marketing and Accounting. And this is exactly what I want to achieve.

I've created 2 tables in my database to have the same column and values as the inline method above. When I bring these tables in, my script looks something like this ..

----------

section access;

LIB CONNECT TO 'demoDB(124psu)';

LOAD "ACCESS",
"USERID",
ACCESSID;
SQL SELECT "ACCESS",
"USERID",
ACCESSID
FROM "SAT"."USER_SECTION_ACCESS";

section application;

LOAD ACCESSID,
ORGANIZATION;
SQL SELECT ACCESSID,
ORGANIZATION
FROM "SAT"."USER_ORGANIZATION";

after executing the script I get this error message - "Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script."

After some research, this usually stems from not including the internal scheduler and myself as an admin with an "*" but I have all those in place in my database tables.

I expect this to work the same as the inline method since I have the same column and values as the inline method. What am I missing here?

Re: section access using database connection

124psu — Thu, 30 Jan 2020 17:34:31 GMT

Quick update - I was able to get the script to execute and working using the database method.

section access;

LOAD upper("ACCESS") as ACCESS,
upper("USERID") as USERID,
upper(ACCESSID) as ACCESSID;
SQL SELECT "ACCESS",
"USERID",
ACCESSID
FROM etc

section application;

LOAD upper(ACCESSID) as ACCESSID,
ORGANIZATION as Organization;
SQL SELECT ACCESSID,
ORGANIZATION
FROM etc

topic Re: section access using database connection in App Development

section access using database connection

Re: section access using database connection