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: 3053
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 PuTTY - "User is not a surrogate... IBM Tools 5
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts user exit in IBM Infosphere Optim DB2 8
No new posts Running a Job with the Default User ID JCL & VSAM 2
No new posts the system or user abend SF0F R=NULL COBOL Programming 0
Search our Forums:

Back to Top