Who are all opening my datasets



Post anything related to mainframes (IBM & UNISYS) if not fit in any of the above categories

Who are all opening my datasets

Postby Subbarao » Wed Feb 19, 2014 11:05 pm

Hi,

I will be creating few datasets on weekly basis, i need to generate list of users who has access the datasets, is there any mechanism to the get the list.
Subbarao
 
Posts: 3
Joined: Wed Feb 19, 2014 10:54 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Who are all opening my datasets

Postby enrico-sorichetti » Thu Feb 20, 2014 12:32 am

why not speak top Your support ???

if You have the business need they will be happy to provide You with the proper advice
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Who are all opening my datasets

Postby dick scherrer » Thu Feb 20, 2014 1:00 am

Hello and welcome to the forum,

i need to generate list of users who has access the datasets

Why does someone believe such a list is needed?

What about those who actually open these dataset in addition to being able to access them?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Who are all opening my datasets

Postby Robert Sample » Thu Feb 20, 2014 5:00 am

Access is controlled via the security software -- RACF, ACF2, TOP SECRET among them -- and may include many people who never open a single one of these data sets. Finding out who opened a data set will require using the SMF records.

I think your first issue is to determine whether you want to know who COULD open your data sets, or who DID open your data sets -- security package and SMF data records are very different types of data.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Who are all opening my datasets

Postby Subbarao » Thu Feb 20, 2014 3:33 pm

Thanks Every body.

Robert Sample wrote:Access is controlled via the security software -- RACF, ACF2, TOP SECRET among them -- and may include many people who never open a single one of these data sets. Finding out who opened a data set will require using the SMF records.

I think your first issue is to determine whether you want to know who COULD open your data sets, or who DID open your data sets -- security package and SMF data records are very different types of data.


@Robert: Thanks for the info, I have list of datasets generated by me. I need list of users who did open the datasets. Please help me in getting the list.
dick scherrer wrote:Hello and welcome to the forum,

i need to generate list of users who has access the datasets

Why does someone believe such a list is needed?

What about those who actually open these dataset in addition to being able to access them?

@Dick: Thank you Dick. I need to include them as well in the list.

enrico-sorichetti wrote:why not speak top Your support ???

if You have the business need they will be happy to provide You with the proper advice

@Enrico: There was a business need with this requirement, so i need to generate the report.
Subbarao
 
Posts: 3
Joined: Wed Feb 19, 2014 10:54 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Who are all opening my datasets

Postby NicC » Thu Feb 20, 2014 3:42 pm

enrico-sorichetti wrote:why not speak top Your support ???

if You have the business need they will be happy to provide You with the proper advice


@Enrico: There was a business need with this requirement, so i need to generate the report.

Why should a business need stop you from going to your support who are also there to support the business? They could, possibly, give you a job to run that will do what you need.
Robert Sample wrote:Access is controlled via the security software -- RACF, ACF2, TOP SECRET among them -- and may include many people who never open a single one of these data sets. Finding out who opened a data set will require using the SMF records.

I think your first issue is to determine whether you want to know who COULD open your data sets, or who DID open your data sets -- security package and SMF data records are very different types of data.



@Robert: Thanks for the info, I have list of datasets generated by me. I need list of users who did open the datasets. Please help me in getting the list.

Robert has helped you to get the list. You need to access the SMF records to find who has actualy opened the datasets as he has said. Now you have to go and speak to the people who handle the SMF records in your organisation. There is a business need so they cannot refuse to help.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Who are all opening my datasets

Postby enrico-sorichetti » Thu Feb 20, 2014 4:42 pm

the term/construct business need means that the requirement is known/suppoorted organization wide,

so that You are authorized/requested to involve the proper functions
-- in this case audit/storage/security support

to check if something alike is in place
-- in order not to reinvent the wheel

and to be advised about the proper practices to be used in Your organization.

and to be advised about the tools already available

not wanting to contact the proper functions inside Your organization implies
that Your requirement is not an organization wide business need


PS.
reporting on dataset access id a task that is commonly done everywhere
so there should be no need to reinvent anything

just get in touch with the audit/storage/security people in order to add
Your datasets to the audit list
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Who are all opening my datasets

Postby dick scherrer » Thu Feb 20, 2014 10:32 pm

Hello,

To get the list of who opened what, yu want to use something that should already exist.

You do not want to start from scratch to read the raw SMF data to get your info. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Who are all opening my datasets

Postby nevilh » Sun Feb 23, 2014 6:41 pm

If these are your datasets the quickest/easiest way to find out who is accessing them is to change UACC to NONE and Failed Accesses to warn. This will write a message to the syslog every time someone accesses the datasets. Then you don't have the hassle of going through the SMF data.
nevilh
 
Posts: 39
Joined: Wed Jun 01, 2011 8:28 pm
Has thanked: 0 time
Been thanked: 3 times


Return to All other Mainframe Topics

 


  • Related topics
    Replies
    Views
    Last post