DB2 - L

Native SP creation in Devops environment

  • 1.  Native SP creation in Devops environment

    Posted 3 days ago
    Our DEVOPS environment wants to use a "single" service ID for creation of Native Stored Procedures across all applications. What are others doing for authorities?  I am thinking DBADM without dataacess, hoping this will allow Drop/Create of SP and Grant execute. Does this make sense? We also make use of Bindagent for similar one-id bind authorizations. Are there better solutions?

    Thanks,

    Larry

    ------------------------------
    LarryJardine
    Aetna, a CVS Health Company
    ------------------------------