RE: No entry for *PUBLIC on library

Now I'm more confused.

I am running a program that is owned by a *SECOFR profile and adopts its authority. I have checked both parts of that statement and they are correct.

It is doing an SQL "select * from qsys2.object_privileges". When it runs, it returns only my group profile. Does this SQL select statement not utilize the adopted authority?

-----Original Message-----
From: smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Thursday, April 4, 2024 12:30 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: No entry for *PUBLIC on library

I just found that same answer. To be clearer on it...

I only have *USE authority to the library so it only shows my profile / group profile's authority to it and no others. I get the same result if I have *CHANGE. However, if I have *ALL, I can see everything.

I guess I have never had just *USE to a library.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Thursday, April 4, 2024 12:20 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: No entry for *PUBLIC on library

Simple.
CRTLIB DELETEME
CRTUSRPRF DUMMY PASSWORD(redacted)
GRTOBJAUT OBJ(DELETEME) OBJTYPE(*LIB) USER(DUMMY) AUT(*USE) Sign on as dummy dummy cannot see *public. They can use the library but they cannot see other such details.


On Thu, Apr 4, 2024 at 12:11 PM <smith5646midrange@xxxxxxxxx> wrote:

Correction to this question.



Someone with *ALLOBJ just looked at the library and there are other
profiles / group profiles including *PUBLIC. Why can I only see my
profile group on this library and nothing else? If I look at other
libraries on the same system, I see profiles and groups other than
what I belong to.



From: smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Thursday, April 4, 2024 11:53 AM
To: 'Midrange Systems Technical Discussion'
<midrange-l@xxxxxxxxxxxxxxxxxx

Subject: No entry for *PUBLIC on library



I have a library that when I do option 5 to display the authority,
there is no entry for *PUBLIC. The authorization list is *NONE. I
have never seen an object without any entry for *PUBLIC. Does this
mean it is *PUBLIC *EXCLUDE or what is the authority for *PUBLIC?

--
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.

--
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.