Re: IACS run SQL Scripts as different user with elevated privileges

You can create a specific connection in iAcs.

Add an host name to c:\windows\system32\drivers\etc\hosts:

123.123.123.123 NewSysName

Create a new system in iAcs named NewSysName without a specific user

Open Sql Scripts, go to Connections and choose NewSysName.

HTH

P.S. Don't use QSECOFR: it's dangerous and useless.

--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco


Il giorno mer 13 dic 2023 alle ore 16:56 Bob Schwartz <
rschwartz@xxxxxxxxxxxxxxx> ha scritto:

I start my iACS using my regular user profile, without any special
authority or privileges.
In my 5250 sessions I can login as a user with higher authority like
QSECOFR and run tasks.

Is there a way to start Run SQL Scripts with elevated user privileges?
Currently when I click Run SQL Scripts the session runs as my regular user
profile.
Can I start a Run SQL SQL scripts session as say QSECOFR?

Thank you,
Bob Schwartz
Director of Technology Services
Glynn County Board of Education
5505 Altama Ave
Brunswick, GA 31525

--
This is a staff email account managed by Glynn County School District.
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender.
--
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.