Hi,
I'm trying to find what the equivlant SQL privileges are for IBM object authorities. We have the following ten IBM authorities
and the following SQL privileges :
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
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.
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
Code:
ALTER , DELETE , INDEX , INSERT , REFERENCES , SELECT , UPDATE
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.
Comment