RE: Rovoke insert permission but still can insert
Did you log off and back in??
I have seen this before where user didn't have permission and then we granted
them and still didn't work until they log off and back in then they were good.
Bruce Simms
Data Base Services
TALX, Provider of Equifax Workforce Solutions
2330 Ball Drive
St. Louis, MO 63146
Phone (314) 214-7703
Cell (314) 496-6883
FAX (314) 983-3238
Bruce.Simms@Equifax.com
IBM Champions
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of RAFAEL
ALTUNGY
Sent: Tuesday, September 19, 2017 6:23 AM
To: ids@iiug.org
Subject: [IE] Rovoke insert permission but still can insert [39908]
I have issued these commands:
revoke dba from rafael;
revoke resource from rafael;
revoke all on tmp_rosas from rafael;
grant select on tmp_rosas to rafael;
grant insert on tmp_rosas to rafael;
revoke insert on tmp_rosas from rafael;
But the user rafael is be ing able to insert records in the table. The publi
group has connect privilegies but I can't revoke them.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
This message contains proprietary information from Equifax which may be
confidential. If you are not an intended recipient, please refrain from any
disclosure, copying, distribution or use of this information and note that
such actions are prohibited. If you have received this transmission in error,
please notify by e-mail postmaster@equifax.com. Equifax® is a registered
trademark of Equifax Inc. All rights reserved.