Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sgtwilko
Starting Member
23 Posts |
 Posted - 2002-09-25 : 11:17:48
|
I am trying to select all functions (but not functions that return tables) and procedures that have not been given public execute rights.I've got as far as selecting the correct functions and procedures, but can not find a way to select them on a permisions basis.select Routine_name from INFORMATION_SCHEMA.ROUTINES where (Routine_type='FUNCTION' and Data_type!='TABLE') or (Routine_type='PROCEDURE' and left(Routine_name,2)!='dt') Thanks-- Eagles may soar,but Weasels aren't sucked into jet engines. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-25 : 11:35:35
|
| Have you looked at sp_helprotect? It's documented in Books Online. It might make the job easier to INSERT...EXEC sp_helprotect the results into a (temp) table and then query that table for procedures that match the criteria you need. |
 |
|
|
|
|
|
selecting Procedures with permissions