SQL equivalent of GRTOBJAUT using Authorization List
Using SQL script, how does one grant object authority to a table using an authorization list?
This fails because MyAutList is not a *USRPRF:
grant all on table mylib.mytable to MyAutList
This works, but is not what I need:
grant all on table mylib.mytable to Public
Software/Hardware used:
AS/400
ASKED:
April 28, 2011 5:03 PM
UPDATED:
May 2, 2011 1:14 PM
Other Answers:
Hello,
Please write to my email address box: (khalifamorin@yahoo.com)
My name is Morin, a good looking girl.
I
became interested in you after going through your profile today and i wish to
continue relationship with you which if nature will permit we have a
long way to go.
I
have a special reason of contacting you which i will make known to you,
tell you more about myself and also send my pictures to you. I will
like you to get back to me through my email address:
(khalifamorin@yahoo.com)
Morin
To see other answers submitted to the Answer Wiki: View Answer History.
SQL has no such concept. However, normal system commands work for SQL tables, so the GRTOBJAUT command can assign an *AUTL to a table.
Tom
Tom – thanks for your answers, I will pursue the QCMDEXC stored procedure route. This has long been a puzzler to me.
Because you can call QCMDEXC without requiring any return parameter values, it can called as a stored procedure without needing to register it first as a stored procedure.
In the SQL CALL, remember that the ‘Length’ will need to be supplied as a DEC(15 5) value, e.g., 0000000123.0000 would be a 123-byte long command string. That’s probably the single biggest detail that trips these things up.
Tom