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: 15
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: 2771
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 non-system user tasks in CICS CICS 1
No new posts Alter User LOGON Script Parameters CLIST & REXX 11
No new posts Revoke on DB2 to remove an user DB2 4
This topic is locked: you cannot edit posts or make replies. Is there a way to restrict user login... All Other Mainframe Topics 11
No new posts DITTO/ESA R3 User's Guide and Referen... IBM Tools 3
Search our Forums:

Back to Top