[IQUG] [iqug] RE: Where are these perms stored in IQ?

Gehman, Kirby kirby.gehman at sap.com
Wed Mar 27 08:01:59 MST 2019

Take a look at SYSTABAUTH.

drop user kirby;
create user kirby identified by kirby1;
drop table if exists test;
create table test(a int);
grant truncate on test to kirby;
grant select on test to kirby;
select * from systabauth where grantee = 'kirby';

grantor     grantee    screator     stname   tcreator     ttname      selectauth insertauth deleteauth updateauth updatecols alterauth referenceauth loadauth truncateauth
----------- ---------- ------------ -------- ------------ ----------- ---------- ---------- ---------- ---------- ---------- --------- ------------- -------- ------------
dba         kirby      dba          test     dba          test        Y          N          N          N          N          N         N             N        Y
(1 rows)

Kirby Gehman
Platinum Technical Support Engineer
Digital Business Services
SAP North America
T +1 519 883-4803, E kirby.gehman at sap.com

http://www.sap.com/ unsubscribe<https://global.sap.com/profile/unsubscribe.epx?PID=10386&PFID=12894>

From: iqug-bounces at iqug.org <iqug-bounces at iqug.org> On Behalf Of Louie, David
Sent: Wednesday, March 27, 2019 9:46 AM
To: iqug at dssolutions.com
Subject: [IQUG] [iqug] Where are these perms stored in IQ?

I cannot seem to find these perms in any system tables or looking in the wrong place

  *   Load table , create any table, load any table, truncate any table, setuser..

Does anyone know how to generate these?


This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/compliance/privacy-policy for more information about BlackRock’s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/about-us/contacts-locations.

© 2019 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20190327/f05aba1f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4700 bytes
Desc: image001.png
URL: <http://iqug.org/pipermail/iqug/attachments/20190327/f05aba1f/attachment-0001.png>

More information about the IQUG mailing list