ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Equivalences between IBM Object authorities and SQL privileges

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Equivalences between IBM Object authorities and SQL privileges

    Hi,

    I'm trying to find what the equivlant SQL privileges are for IBM object authorities. We have the following ten IBM authorities

    Code:
     *OBJALTER, *OBJEXIST, *OBJMGT, *OBJOPR, *OBJREF, *ADD, *DLT, *READ, *UPD, *EXECUTE
    and the following SQL privileges :

    Code:
    ALTER , DELETE , INDEX , INSERT , REFERENCES , SELECT , UPDATE
    I have not been successful in finding out the equivalences between the two. For example, what is the appropriate SQL command for the following IBM command

    Code:
    GRTOBJAUT OBJ(TEST)
    OBJTYPE(*FILE)
    USER(USER1)
    AUT(*OBJMGT *OBJOPR *READ *EXECUTE)
    Code:
    GRANT ????? ON TEST TO USER1

    We have a program that allows users to indicate the IBM authorities to give on an object to a user but we need to change the GRTOBJAUT to SQL commands using the SQL command GRANT... Is this possible?

    Thank you.

  • #2
    Why not just executing the GRTOBJAUT command
    ... and then doing a reverse enginieering (ACS or with the GENERATE_SQL Stored Procedure) for generating the SQL skript (including the authorities)
    ... you should see the SQL equivalent (or may be there is none then you should see the GRTOBJAUT command)

    Comment


    • #3
      Thanks, I didn't know about the GENERATE_SQL procedure. We'll check it out.

      Comment

      Working...
      X