IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Revoke USER in DB2


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
inforajesh

New User


Joined: 09 Dec 2020
Posts: 20
Location: India

PostPosted: Mon Jul 05, 2021 10:05 am
Reply with quote

Hello,

I am trying to REVOKE particular user (XXXX) access from table/view.
Before executing the REVOKE, I see two different lines of entries (DELETE /SELECT /INSERT/ UPDATE privileges) at BMC Catalog manager for the same user.

After executing REVOKE SPUFI, I am getting return code 0. However I see one entry of privileges still exist at Catalog manager.
If I try to execute the same SPUFI again to remove the second entry. I am getting -556 (But I verified SYSTABAUTH and found one entry there)

Can someone share thoughts or advise to REVOKE user access at one go ?
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3087
Location: NYC,USA

PostPosted: Tue Jul 06, 2021 9:44 pm
Reply with quote

REVOKE (table or view privileges) Did you use ALL?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts User ABEND U0476. Need help. IMS DB/DC 0
No new posts System add a USER parm when job submi... TSO/ISPF 4
No new posts can an ISPF appl save user changes in... TSO/ISPF 14
No new posts COBOL 6.4 - User Defined Function nee... COBOL Programming 6
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
Search our Forums:


Back to Top