Re: Access to Run SQL Scripts Without *ALLOBJ

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

It's very possible someone put some application restrictions in Navigator.
check that next.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Tue, Nov 14, 2023 at 12:31 PM Richard Weber <rweber@xxxxxxxxxxxxxx>
wrote:

> I have a user that needs access to the "Run SQL Scripts" function from the
> Client Solutions Emulator.   We have found that the message "MSGDB0036 -
> Server returned SQL error (The connection does not exist.)" comes up when
> the function is selected and the sql window does not open.  When we change
> the user profile to add *ALLOBJ special authority, the SQL window opens
> up.  Please note this is prior to entering or running any SQL command.
>
> When the user uses STRQRY or STRDFU from a green screen command line, they
> can open the file and view data without *ALLOBJ.   This makes me think that
> there is something running in the background to open the "Run SQL Scripts"
> function that needs some higher object authority to run.
>
> Richard Weber
> IS Data Architect
> rweber@xxxxxxxxxxxxxx
>
> [cid:image001.png@01DA16FC.1C77E4C0]
>
> 104 Coleman Blvd.
> Savannah, GA  31408
>
> Cell: (973) 219-1208
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.