Hello all.
Sql server.
Our dba wants ALL objects our ( developers) scripts are touching.
So if we have an SP_1 that inserts to Table_1 and Table_1 has a trigger TR_1 which does select of Table_2 ,
then we need to tell him that our feature needs permissions to :
sp_1 , table_1 , table_2 , tr_1
Has anyone here have seen such scripts that takes an sp , and dives into it ?
Sql server.
Our dba wants ALL objects our ( developers) scripts are touching.
So if we have an SP_1 that inserts to Table_1 and Table_1 has a trigger TR_1 which does select of Table_2 ,
then we need to tell him that our feature needs permissions to :
sp_1 , table_1 , table_2 , tr_1
Has anyone here have seen such scripts that takes an sp , and dives into it ?