[AD] Grant Access to all tables in same schema

Philip Sevetson

[AD] Grant Access to all tables in same schema
Product plugs are, of course, acceptable. Please tag them.

From: Rasmussen, Steen [mailto:[login to unmask email]
Sent: Tuesday, February 06, 2018 9:21 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Grant Access to all tables in same schema

Hello Mohamed,

Warning up front : stop reading if you don’t want a vendor plug.
If you are looking for NATIVE Db2 security (meaning GRANT’s), CA RC/Secure has a component called SRS where you can create user domain and application domains. You specify all the users who need certain access in the User Domain, you specify the tables (can be generic specification like PROD1.T% for example). Every time you execute the SRS command, we will look in the Db2 catalog and identify all the tables matching the domain and execute the GRANT’s. You can even apply a deadline if needed so the GRANT’s will be revoked once the deadline is met.

Steen Rasmussen

From: Mohamed Esmael [mailto:[login to unmask email]
Sent: Tuesday, February 06, 2018 5:16 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Grant Access to all tables in same schema

CAUTION: This email originated from outside of CA. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hi ALL,

I want to give access to the tables created with particular schema, to Particular team
Is there any SQL command. in DB2 V11 z/OS where i can give SELECT access
to all the tables created with the particular schema, since i have more than 400
tables scattered in more than one database.

Thank you all for your help

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**