Jim Youmans
asked on
DB2 Drop User Completely
DB2 10.5 LUW on Windows 2012
I have some users that are no longer with the company and I need to drop them from the database. I revoked all of there permissions but they still show up under the SECURITY > USERS list.
I tried DROP USER MAPPING but it gave me the error: SQL20076N The instance for the database is not enabled for the specified action or operation. Reason code = "1".
Even though I have revoke all permissions for them, the Security chief wants them off the user report that we run.
Any thoughts? Thank you!!!
I have some users that are no longer with the company and I need to drop them from the database. I revoked all of there permissions but they still show up under the SECURITY > USERS list.
I tried DROP USER MAPPING but it gave me the error: SQL20076N The instance for the database is not enabled for the specified action or operation. Reason code = "1".
Even though I have revoke all permissions for them, the Security chief wants them off the user report that we run.
Any thoughts? Thank you!!!
ASKER
No, there are not.
The DROP USER MAPPING command drops the user (mapping) across federated servers.
What tool are you using that shows the old users?
What tool are you using that shows the old users?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Toad for DB2.
Well, crap. I had to close Toad and now that I have re-opened it the user is gone. WTH? OK, so Toad must cache it or something. Sorry to waste your time. :(
Well, crap. I had to close Toad and now that I have re-opened it the user is gone. WTH? OK, so Toad must cache it or something. Sorry to waste your time. :(
ASKER
Kent is the best. Bar none!
Oh, man.... We should have started with the "This is Windows so reboot" approach! ;)
SELECT schemaname from syscat.schemata -- look for select schemas
or
SELECT * FROM syscat.schemata where owner = 'SOMEUSER' -- look for schema owned by user