I needed to copy the permissions from one database to another but the sp__helprotect stored procedure in Ed Barlow’s Extended System Stored Procedure Library for Sybase and Sql Server wasn’t producing output with “GRANT” and “REVOKE”. It also had problems with DBCC privileges. Here you go: sp__helprotect.sql /* Procedure copyright(c) 1995 by Edward M Barlow [...]
Ed Barlow’s sp__helprotect updated for SAP Sybase ASE 15.7 Solved
by Jason L Froebe on April 23, 2013, no comments
