Check for grants
774329Jul 28 2010 — edited Jul 28 2010I need to check if the grants are already given for a particular procedure/table/package. If the grants are not given then I have to give the grants, but if the grants exists then I just want a display saying that grants are already present.
Am trying to put this in a shell script, can anyone help.
Note: There are a set of 12 grants to be given and it is common for every package,table,function or package. Eg: grant execute on &&1 to GENERAL - I have 12 such schemas which needs to be checked.
please let me know if i can provide any further input.