We help IT Professionals succeed at work.
Get Started

DELETE Permissions

Los Angeles1
Los Angeles1 asked
Last Modified: 2013-12-10
I performed the following command, and have a couple questions

db2 => select grantor, grantee, tcreator, ttname, deleteauth, insertauth from sysibm.systabauth where ttname = 'CATALOG'

GRANTOR                                                                                                                          GRANTEE                                                                                                                          TCREATOR                                                                                                                         TTNAME                                                                                                                           DELETEAUTH INSERTAUTH
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ---------- ----------
SYSIBM                                                                                                                           DB2INST1                                                                                                                         DB2INST1                                                                                                                         CATALOG                                                                                                                          G          G
DB2INST1                                                                                                                         PUBLIC                                                                                                                           DB2INST1                                                                                                                         CATALOG                                                                                                                          Y          Y

  2 record(s) selected.

Open in new window

1> What does the value 'G' mean in the DELETEAUTH field

2> Does this mean db2inst1 has explicit DELETE permission

3> Does this mean db2inst1 has implicit DELETE permissions

4> What is the difference between GRANTOR, GRANTEE, and  TCREATOR

Watch Question
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE