Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

db2 authority sql

Status
Not open for further replies.
cougartrace

cougartrace

Technical User
Sep 9, 2003
29
US
Hi all,

Does anyone have any SQL that will show all the select,insert, and update authority for every table in a DB2 database?

CougarTrace
 
Sort by date Sort by votes
Does the following help

select * from sysibm.systabauth

Cheers
Greg

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
391
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
300
tekpr00
tekpr00
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
250
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
306
walter.weinmann
walter.weinmann
MichaelDe
  • Locked
  • Question
SQL Update with File Join
Replies
10
Views
1K
MichaelDe
MichaelDe

Part and Inventory Search

Sponsor

Back
Top